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

From Nabil Sayegh
Subject Re: How to easily spot Foreign keys
Date
Msg-id 1060790433.1593.15.camel@billy
Whole thread Raw
In response to How to easily spot Foreign keys  (Harry Broomhall <harry.broomhall@uk.easynet.net>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Jason Hihn
Date:
Subject: Re: How to easily spot Foreign keys
Next
From: Nabil Sayegh
Date:
Subject: Re: How to easily spot Foreign keys