Thread: Data types
Hi guys, Does Postgres store all the possible column datatypes somewhere in its system tables? Like int8, int4, character varying, etc. I'm trying to write another GUI client that can list all the database objects in Postgres. Thanks. Regards, Jonel -- I know not english well, but I know 9 computer languages. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005
On Fri, Dec 30, 2005 at 12:57:57PM -0600, Jonel Rienton wrote: > Does Postgres store all the possible column datatypes somewhere in its > system tables? Like int8, int4, character varying, etc. I'm trying to write > another GUI client that can list all the database objects in Postgres. See "System Catalogs" in the documentation; here's a link to the latest version: http://www.postgresql.org/docs/8.1/interactive/catalogs.html You might also want to check out the Information Schema, which is defined in the SQL standard. http://www.postgresql.org/docs/8.1/interactive/information-schema.html -- Michael Fuhr
Try pg_type. typname should give you what you're looking for. On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote: > Hi guys, > > Does Postgres store all the possible column datatypes somewhere in its > system tables? Like int8, int4, character varying, etc. I'm trying > to write > another GUI client that can list all the database objects in Postgres. > Thanks. > > Regards, > > Jonel > > -- > I know not english well, but I know 9 computer languages. > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: > 12/30/2005 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >
Thank you gentlemen, this will keep me busy for a while. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of James Cradock Sent: Friday, December 30, 2005 1:05 PM To: Jonel Rienton Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Data types Try pg_type. typname should give you what you're looking for. On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote: > Hi guys, > > Does Postgres store all the possible column datatypes somewhere in its > system tables? Like int8, int4, character varying, etc. I'm trying to > write another GUI client that can list all the database objects in > Postgres. > Thanks. > > Regards, > > Jonel > > -- > I know not english well, but I know 9 computer languages. > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: > 12/30/2005 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005