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

From Jason Hihn
Subject Re: How to easily spot Foreign keys
Date
Msg-id NGBBLHANMLKMHPDGJGAPEEFMCMAA.jhihn@paytimepayroll.com
Whole thread Raw
In response to Re: How to easily spot Foreign keys  (Harry Broomhall <harry.broomhall@uk.easynet.net>)
Responses Re: How to easily spot Foreign keys
List pgsql-novice
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@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Harry Broomhall
> Sent: Wednesday, August 13, 2003 11:50 AM
> To: Stephan Szabo
> Cc: harry.broomhall@uk.easynet.net; pgsql-novice@postgresql.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
>


pgsql-novice by date:

Previous
From: Harry Broomhall
Date:
Subject: Re: How to easily spot Foreign keys
Next
From: Nabil Sayegh
Date:
Subject: Re: How to easily spot Foreign keys