Re: How to easily spot Foreign keys

Am Mit, 2003-08-13 um 17.35 schrieb Harry Broomhall:

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

pg_dump dbname |grep -i constraint
there you will find information about

table
foreign_table
field
foreign_field

the ordering might actually be different.
I wrote scripts several times to automatically convert the triggers to
7.3 style triggers, but always got bored in the end and never finished
:)
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de