Re: [GENERAL] Describe table and varchar lrngth

2004-07-15 Thread Tony Li
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 = '' and c.relname = '' The result needs to be parsed... Tony On Jul 15, 2004, at 1:38 AM, Constantin Khatsckevich wrote: Hello! I need get ordered lengt

[GENERAL] Describe table and varchar lrngth

2004-07-15 Thread Constantin Khatsckevich
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)-