Remove Postgres VARCHAR in favor of TEXT with check constraint

[Jaymon]

So instead of VARCHAR(256) I would do:

<COLNAME> TEXT NOT NULL CHECK (length(<COLNAME>) <= 256)

You can also easily modify the checks:

ALTER TABLE <TABLE NAME> ADD CONSTRAINT <CONSTRAINT-NAME> CHECK (length(<COLNAME>) <= 128)

This should work in both SQLite and Postgres. CHECK constraints can also be more involved like regexes and stuff

Links

• Should I add an arbitrary length limit to VARCHAR columns?
• SQLite CHECK constraints
• Difference between text and varchar (character varying)

Search

• sqlite add constraint check