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.