For my purposes, I was happier to get the output of format_type() and
parse it. This meant that I didn't have to carry around some magic
constant that wasn't part of the documented interface...
Tony
On Jul 19, 2004, at 2:31 PM, Stephan Szabo wrote:
> 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
>
