Re: system catalog and varchar datatype

On Mon, 19 Jul 2004, sandra ruiz wrote:

> hi, I need to find out the length of a varchar attribute ..
>
> for example,if a I have an atribute "description varchar(256)"  I would
> expect to see this "256" in the pg_attribute table.
>
> there's is an "attlen" In the pg_attribute but this doesn't give any
> information

Atttypmod gives this information, but the value is datatype specific.

For varchar (and char) at least, the atttypmod is 4 greater than the
maximum length, so atttypmod for the above would be 260.