varchar size - Mailing list pgsql-hackers

From Andy Farrell
Subject varchar size
Date
Msg-id n1321376514.87451@itd.sterling.com
Whole thread Raw
List pgsql-hackers
REGARDING                varchar size

Given the results of a query using the perl interface to postgres, how can I
find the maximum length of the data returned for the varchar fields in the
query?

Is there something in the "results" buffer or can I query the system catalogs
for this information?  If you need to query the system catalogs, what field
actually contains the maximum length of a varchar field?  In other words, how
can I find what the field was defined as in the create table statement (e.g.,
...attribute1  varchar(12)...) using the system catalogs?

TIA,
Andy


pgsql-hackers by date:

Previous
From: Brandon Ibach
Date:
Subject: Re: [HACKERS] Data type removal
Next
From: Tom Ivar Helbekkmo
Date:
Subject: Re: [HACKERS] mega-patch--tcl/tk configuration