| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonel Rienton | 2005-12-30 19:19:03 | Re: Data types |
| Previous Message | James Cradock | 2005-12-30 19:05:22 | Re: Data types |