| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: How to easily spot Foreign keys |
| Date: | 2003-08-13 16:00:33 |
| Message-ID: | 1060790433.1593.15.camel@billy |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Hihn | 2003-08-13 16:04:39 | Re: How to easily spot Foreign keys |
| Previous Message | Gerard MacNeil | 2003-08-13 15:56:41 | postgres on AIX |