how do I do to get the foreign keys of a table?

Поиск
Список
Период
Сортировка
Искать
От
Roberto (SmartBit)
Тема
how do I do to get the foreign keys of a table?
Дата
Msg-id
013a01c27771$66255e50$1501a8c0@NoteBook
Список
Дерево обсуждения
how do I do to get the foreign keys of a table? "Roberto (SmartBit)" <roberto@smartbit.inf.br>
Re: how do I do to get the foreign keys of a table? Stephan Szabo <sszabo@megazone23.bigpanda.com>
This is my SQL to return the constraints...

select tgconstrname, tr.relname, fr.relname from pg_trigger, pg_class tr,
pg_class fr
where tr.oid = tgrelid and fr.oid = tgconstrrelid and
tr.relname='MyTableName'

 so, how do I do to get the  foreign keys of a table?

let me be more explicite, I want to get the name of fields from a table that
are related with other table! (foreign key)

NOTE: I want a SQL command to get it from any table of any PostgreSQL
database, so it can not be a function!

please help me

tia

Roberto de Amorim

В списке pgsql-general по дате отправления
От: Williams, Travis L, NPONS
Дата:
Сообщение: Re: table overflow question
От: Williams, Travis L, NPONS
Дата:
Сообщение: Connection timeout..
FAQ