| From: | Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net> |
|---|---|
| To: | sszabo(at)megazone(dot)bigpanda(dot)com (Stephan Szabo) |
| Cc: | harry(dot)broomhall(at)uk(dot)easynet(dot)net, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: How to easily spot Foreign keys |
| Date: | 2003-08-13 15:50:06 |
| Message-ID: | 200308131550.QAA17535@haeb.noc.uk.easynet.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerard MacNeil | 2003-08-13 15:56:41 | postgres on AIX |
| Previous Message | Stephan Szabo | 2003-08-13 15:39:41 | Re: How to easily spot Foreign keys |