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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
