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

Re: Data types

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jonel Rienton <jonel(at)rientongroup(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data types
Date: 2005-12-30 19:06:30
Message-ID: 20051230190629.GA47895@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

  • Data types at 2005-12-30 18:57:57 from Jonel Rienton

pgsql-general by date

Next:From: Jonel RientonDate: 2005-12-30 19:19:03
Subject: Re: Data types
Previous:From: James CradockDate: 2005-12-30 19:05:22
Subject: Re: Data types

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