Re: Field size

From: Ludwig Kniprath <ludwig(at)kni-online(dot)de>
To: <martin(at)cornhobble(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Field size
Date: 2008-07-21 15:59:05
Message-ID: 27628784.33171216655945861.JavaMail.servlet@kundenserver
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-07-21 16:13:29 Re: Problems using Grails with Postgresql
Previous Message Martin 2008-07-21 15:53:51 Re: Field size