>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