Re: How to easily spot Foreign keys - Mailing list pgsql-novice

On Wed, 13 Aug 2003, Harry Broomhall wrote:

>     I am currently doing a bit of 'reverse engineering' and documenting
> a set of tables.
>
>     Using pgsql and the \d command produces info about most things, but
> doesn't *obviously* produce foreign key or references info.

I believe 7.3's \d should provide foreign key info (for constraints made
in 7.3 or for which you've run adddepend from contrib if you've upgraded
from 7.2).