field types - Mailing list pgsql-admin

From Reshma Choodanath
Subject field types
Date
Msg-id 35AC423E.233EE2A1@wipinfo.soft.net
Whole thread Raw
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] Upgrade problem, with GRANT
Next
From: "Rob den Boer"
Date:
Subject: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2