how to view table foreign keys/triggers?

From: Karin Nila Huegele <forcecommander(at)lorecrafters(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to view table foreign keys/triggers?
Date: 2002-07-02 22:51:07
Message-ID: 1025650273.25872.293.camel@forcecommander
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 --

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Henk Schets 2002-07-03 07:32:17 sequences what does ::text mean ?
Previous Message robert kraus 2002-07-02 22:29:06 Importing complete txt file with column names