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:

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

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