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)
pgsql-admin by date
|Next:||From: Rob den Boer||Date: 1998-07-15 07:57:49|
|Subject: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2|
|Previous:||From: Bruce Momjian||Date: 1998-07-15 03:50:39|
|Subject: Re: [ADMIN] Upgrade problem, with GRANT|
pgsql-general by date
|Next:||From: Herouth Maoz||Date: 1998-07-15 10:04:26|
|Subject: Re: [INTERFACES][HACKERS] atttypmod now 32 bits, interface change|
|Previous:||From: Vadim Mikheev||Date: 1998-07-15 02:38:01|
|Subject: Re: [GENERAL] Hash index performance/operation questions...|