A Query on PG_ tables

Поиск
Список
Период
Сортировка
От NRonayette
Тема A Query on PG_ tables
Дата
Msg-id 394DDF44.79636CEE@socotec.fr
обсуждение исходный текст
Список pgsql-general
Hi everybody,

    I'm using Postgresql 7.0.

    I want to find, by a query on the postgres table (like pg_class,
pg_attribute, pg_trigger, etc....), the name of all the colonnes  that
are foreign key on my base.

Pg_trigger gives me some information about the foreigns key i added on
my tables (name, id etc..) but i don't know how to join this information
with another pg_<table> (for example, pg_attribute or else) to find the
name of my colonnes that are foreign key.

Someone have an idear ?

I hope i was clear with my poor English...

Thanks for your answers.

Nicolas.

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

Предыдущее
От: Herbert Liechti
Дата:
Сообщение: Re: Lock rekord
Следующее
От: Joost Kraaijeveld
Дата:
Сообщение: RE: PostgreSQL on NT: new cygwin?