News for hackers. Stuff that matters.
Re:Postgres: Boundless `Text` and Back Again by mjw1007 on Friday September 10, 2021 @03:42PM (#28486104)
Another advantage of using `varchar(n)` rather than a constraint is that the limit is visible in `information_schema.columns` and `pg_attribute`, so tools using this sort of introspection have a better chance of doing something useful.

(Incidentally, distinguishing between "text" and "varchar" the way you do in the article can be confusing, because in PostgreSQL plain `varchar` instead of `varchar(N)` is another way of getting an unconstrained character type.)

There are no comments on this comment yet.