Re: accessing user table structures from SQL - Mailing list pgsql-general

From Albe Laurenz
Subject Re: accessing user table structures from SQL
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202F75D6D@exadv11.host.magwien.gv.at
Whole thread Raw
In response to accessing user table structures from SQL  (Vincent Predoehl <vpredoehl@phoenixwebgroup.com>)
List pgsql-general
Vincent Predoehl wrote:
> Sent: Saturday, January 17, 2009 5:33 AM
> Does postgresql have a system table that has the table
> structure of user tables, like systables and sysobjects in MS
> SQL Server?

All the details about database objects are in the system catalogs:

http://www.postgresql.org/docs/current/static/catalogs.html

but, unless you need implementation specific details, most
of the time you are better off with the standard SQL
information schema:

http://www.postgresql.org/docs/current/static/information-schema.html

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Can I separate my Databases as in FireBird? Working with DataBases...
Next
From: "Scott Marlowe"
Date:
Subject: Re: Can I separate my Databases as in FireBird? Working with DataBases...