Chris Hoover wrote: > 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). pg_attribute.atttypmod <> 256 + 4 (your 256 plus fixed 4 bytes of overhead for all variable length attributes). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
