Re: How to easily spot Foreign keys

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to easily spot Foreign keys
Date: 2003-08-13 15:39:41
Message-ID: 20030813083845.N49458-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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).

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Harry Broomhall 2003-08-13 15:50:06 Re: How to easily spot Foreign keys
Previous Message Harry Broomhall 2003-08-13 15:35:54 How to easily spot Foreign keys