Listing the table fields ....

===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-sql(at)postgresql(dot)org
===================================================================

Hi,

This piece of code list the the table fields with the attribute name and the
fieldtype.
How do I get the Field size for that attribute.
f code list the the table fields with the attribute name and the fieldtype.
How do I get the Field size for that attribute?
Eg, Say one of the attributes is :-

name varchar (50)

I want to trap the value 50.

I tried the typlen and typprtlen, but that was not what I was looking for.

# list table fields (attribute) in given table
def ListAllFields(pgcnx, table):
list = []
for node in pgcnx.query("""SELECT c.relname, a.attname, t.typname
FROM pg_class c,
pg_attribute a, pg_type t
WHERE c.relname = '%s'
AND
a.attnum > 0 AND
a.attrelid =
c.oid AND
a.atttypid =
t.oid
""" %
table).getresult():
list.append(node[1], node[2], node[3])
return list

Thanks,
Reshma.