how to view table foreign keys/triggers? - Mailing list pgsql-novice

From Karin Nila Huegele
Subject how to view table foreign keys/triggers?
Date
Msg-id 1025650273.25872.293.camel@forcecommander
Whole thread Raw
Responses Re: how to view table foreign keys/triggers?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error Trapping -duplicate keys
Next
From: robert kraus
Date:
Subject: Importing complete txt file with column names