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 по дате отправления