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:- [EMAIL PROTECTED] Thanks, Reshma.