Postgres Pro
Downloads
Home   >   mailing lists

Re: Field size - Mailing list pgsql-general

From Ludwig Kniprath
Subject Re: Field size
Date
Msg-id 27628784.33171216655945861.JavaMail.servlet@kundenserver
Whole thread Raw
In response to Field size  (Martin <martin@cornhobble.com>)
Responses Re: Field size
List pgsql-general
Tree view 
>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

pgsql-general by date:

Previous
From: "A B"
Date:
Subject: Re: How to remove duplicate lines but save one of the lines?
Next
From: Martin
Date:
Subject: Re: Field size