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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
