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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
