Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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.



pgsql-admin by date

Next:From: Rob den BoerDate: 1998-07-15 07:57:49
Subject: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
Previous:From: Bruce MomjianDate: 1998-07-15 03:50:39
Subject: Re: [ADMIN] Upgrade problem, with GRANT

pgsql-general by date

Next:From: Herouth MaozDate: 1998-07-15 10:04:26
Subject: Re: [INTERFACES][HACKERS] atttypmod now 32 bits, interface change
Previous:From: Vadim MikheevDate: 1998-07-15 02:38:01
Subject: Re: [GENERAL] Hash index performance/operation questions...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group