PSQL Field Length Query

[pennstump]

Is there a way to query the db for the maximum length of a field for error-checking/truncation before writing?

Thanks.

 

[ceco]

here you are a query

SELECT pg_class.relname, pg_attribute.attname, pg_type.typname, pg_attribute.atttypmod-4
FROM pg_class, pg_attribute, pg_type
WHERE pg_attribute.attrelid = pg_class.oid
AND pg_attribute.atttypid = pg_type.oid
AND pg_class.relname = 'TABLE_NAME'
AND pg_attribute.attname = 'FIELD_NAME'

for more information on the pg_catalog you can see here

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=catalogs.html

it is for varsion 7.3