From: | Reshma Choodanath <creshma(at)wipinfo(dot)soft(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | field types |
Date: | 1998-07-15 05:46:39 |
Message-ID: | 35AC423E.233EE2A1@wipinfo.soft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(at)wipinfo(dot)soft(dot)net(dot)
Thanks,
Reshma.
From | Date | Subject | |
---|---|---|---|
Next Message | Rob den Boer | 1998-07-15 07:57:49 | VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 |
Previous Message | Bruce Momjian | 1998-07-15 03:50:39 | Re: [ADMIN] Upgrade problem, with GRANT |
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-07-15 10:04:26 | Re: [INTERFACES][HACKERS] atttypmod now 32 bits, interface change |
Previous Message | Vadim Mikheev | 1998-07-15 02:38:01 | Re: [GENERAL] Hash index performance/operation questions... |