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
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)-