I know it is in the docs, but right now I can't see it.
How do I pull the length of a specific varchar column? I have just found a problem with our schema being out of sync on one specific column, and need to find out how many of our 200+ databases need to be fixed.
Here is what I have so far: select * from pg_class, pg_attribute where pg_class.relkind = 'r' and pg_attribute.attrelid = pg_class.oid and pg_class.relname = 'mytable' and pg_attribute.attname = 'problem_column' and ???? != 256; -- need to report anytime this column is not a varchar(256).