From: | "Andy Farrell" <Andy_Farrell(at)gator-gate(dot)itd(dot)sterling(dot)com> |
---|---|
To: | "PostGreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | varchar size |
Date: | 1998-03-24 13:23:08 |
Message-ID: | n1321376514.87451@itd.sterling.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Farrell | 1998-03-24 13:31:14 | Postgres "in the field" |
Previous Message | The Hermit Hacker | 1998-03-24 12:53:18 | Re: [HACKERS] Data type removal |