Thread: field types

field types

From
Reshma Choodanath
Date:
Hi,

pg_type's attribute, typname gives the type name
of the fields of the table.
Say my table schema is :-

name varchar(50)   age int4;

How do I get the '50' part of the type.
I checked out a few options but always hit a blank
wall, pg_type.typprtlen gives -1 for variable type!!

I'm not a member of the mailing group.
If you have any solutions could you please mail it
to my mail address:- creshma@wipinfo.soft.net.

Thanks,
Reshma.