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