.tip

There is no performance difference between text and varchar(n) in Postgres. The length limit is a check constraint with a worse error message, and changing it later is a migration.

name text NOT NULL CHECK (length(name) <= 200)

If you need a limit, say it as a constraint you can drop or change without rewriting the column type.