Postgres Pro
Downloads
Home   >   mailing lists

how to view constraints (esp foreign keys) for table? - Mailing list pgsql-general

From Frank Miles
Subject how to view constraints (esp foreign keys) for table?
Date
Msg-id Pine.A41.4.21.0011090837260.70580-100000@mead2.u.washington.edu
Whole thread Raw
List pgsql-general
Tree view 
Hello all --

    Is there a convenient way to view the foreign key constraints
for a table from within psql?  Something along the lines of the \d_
commands is what I'm hoping to find...
    The only way I've seen so far is to examine the dumps with a
text editor, which is a bit messy.

TIA!

    -frank

pgsql-general by date:

Previous
From: "mike focosi"
Date:
Subject: Table Corruption
Next
From: Tom Lane
Date:
Subject: Re: More vacuum troubles