Re: Querying for related tables

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Querying for related tables
Дата
Msg-id 436A4494.9080903@archonet.com
обсуждение исходный текст
Ответ на Querying for related tables  ("Craig" <postgresql@bryden.co.za>)
Ответы Re: Querying for related tables
Список pgsql-general
Craig wrote:
> Hi
>
> How can I query for all the tables that are referenced by a particular
> table (i.e my table has 3 foreign keys. I need a query that will return
> the table names of the referenced tables)?

See the chapters on the "Information Schema" (which is an SQL standard)
and the "system catalogs" (which are PostgreSQL specific).

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления: