Re: How to easily spot Foreign keys

I am under the impression (false or not?) that all version 7.x pg dumps are
compatible? So 7.2->7.3 (or 7.4) would not be a problem?

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Harry Broomhall
> Sent: Wednesday, August 13, 2003 11:50 AM
> To: Stephan Szabo
> Cc: harry(dot)broomhall(at)uk(dot)easynet(dot)net; pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>