Re: db andtable schemas
От | George Weaver |
---|---|
Тема | Re: db andtable schemas |
Дата | |
Msg-id | 004401c71c9a$538588b0$6400a8c0@Dell4500 обсуждение исходный текст |
Ответ на | db andtable schemas ("Jamie Lawrence Jenner" <jlj@webgremlins.net>) |
Ответы |
Re: db andtable schemas
|
Список | pgsql-general |
--- Original Message From: Jamie Lawrence Jenner --- > Retrieve a list of tables from a given database > How to retrieve a list of table properties from a table > how retireve what constraints a table has > foreign ekeys > primary keys > I would be really greatful if someone could point me in the direction Jamie, the type of metadata you're looking for is detailed in the Information Schema: http://www.postgresql.org/docs/8.2/static/infoschema-schema.html and the PostgreSQL system catalogs: http://www.postgresql.org/docs/8.2/static/catalogs-overview.html You can use ordinary SQL queries to pull the inforamation you require from these sources. Regards, George
В списке pgsql-general по дате отправления: