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

From Harry Broomhall
Subject Re: How to easily spot Foreign keys
Date
Msg-id 200308131550.QAA17535@haeb.noc.uk.easynet.net
Whole thread Raw
In response to Re: How to easily spot Foreign keys  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: How to easily spot Foreign keys
Re: How to easily spot Foreign keys
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to easily spot Foreign keys
Next
From: Jason Hihn
Date:
Subject: Re: How to easily spot Foreign keys