field types

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.

Browse pgsql-admin by date

  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

Browse pgsql-general by date

  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...