Re: accessing user table structures from SQL

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: accessing user table structures from SQL
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202F75D6D@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на accessing user table structures from SQL  (Vincent Predoehl <vpredoehl@phoenixwebgroup.com>)
Список 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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Can I separate my Databases as in FireBird? Working with DataBases...
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Can I separate my Databases as in FireBird? Working with DataBases...