Re: How to easily spot Foreign keys

Stephan Szabo writes:
>
> 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).


   Many thanks for your rapid reply.  Unfortunately I am trying to
document some 7.2 based tables in advance of upgrading to 7.3!

   Regards,
       Harry.