>On Sun, Jul 20, 2008 at 05:50:30PM -0500, Martin wrote:
>> Ok, this should be simple. How do I find the defined maximum
>> length of a varchar field?

SELECT 
   character_maximum_length 
FROM 
   information_schema.columns
WHERE
   table_schema = 'name_of_your_schema' and 
   table_name = 'name_of_your_table' and 
   column_name = 'name_of_your_column'

bye...
Ludwig

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to