Thread: Describe table and varchar lrngth

Describe table and varchar lrngth

From
Constantin Khatsckevich
Date:
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!


Re: Describe table and varchar lrngth

From
Tony Li
Date:
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
>