Here's what I came up with:
select format_type(a.atttypid, a.atttypmod) from pg_attribute a, pg_class c where a.attrelid = c.oid and a.attname = '<field>' and c.relname = '<relation>'
The result needs to be parsed...
Tony
On Jul 15, 2004, at 1:38 AM, Constantin Khatsckevich wrote:
Hello!
I need get ordered length of the varchcar field in PHP. But pg_FieldLength return -1 (it's right), but I need to get max length for this field. For example,
create table t (
str varchar(40)
);
I need to get 40...
Help me please!
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
