How to easily spot Foreign keys

From: Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to easily spot Foreign keys
Date: 2003-08-13 15:35:54
Message-ID: 200308131535.QAA17484@haeb.noc.uk.easynet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 am aware that the info is buried somewhere in the 'ContraintTrigger'
items, but it isn't obvious how to retrieve the info.

Is there a tool, or a work-around to get this info in a rather more
'user-friendly' fashion?

Regards,
Harry.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2003-08-13 15:39:41 Re: How to easily spot Foreign keys
Previous Message Stephan Szabo 2003-08-13 15:13:47 Re: pqgetresultset problem