how to view table foreign keys/triggers?

Поиск
Список
Период
Сортировка
От Karin Nila Huegele
Тема how to view table foreign keys/triggers?
Дата
Msg-id 1025650273.25872.293.camel@forcecommander
обсуждение исходный текст
Ответы Re: how to view table foreign keys/triggers?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hello,
I was wondering if you could show me how I could find out which columns
in a table are constrained by foreign keys?
I tried \d mytable and then \dd RI_ConstraintTrigger but only got this
on all of the triggers:

     Object descriptions
 Name | Object | Description
------+--------+-------------
(0 rows)

How can I view the content of a trigger?  Is this the best way to learn
about a table's foreign keys?

Thank you very much for your help!

-- karin --




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error Trapping -duplicate keys
Следующее
От: robert kraus
Дата:
Сообщение: Importing complete txt file with column names