Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign key constraint - Mailing list pgsql-general

From Tom Lane
Subject Re: foreign key constraint
Date
Msg-id 4678.1046815908@sss.pgh.pa.us
Whole thread Raw
In response to Re: foreign key constraint  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Tree view 
Dennis Gearon <gearond@cvc.net> writes:
>     a/ The dump of a table on my sytem does NOT show the foreign keys. Somewhere I heard that
> that comes out of a full dump as ALTER statements. I think it should also show up as ALTER
> statements on a table schema dump.

It works that way for me...

            regards, tom lane

pgsql-general by date:

Previous
From: "Mario Weilguni"
Date:
Subject: hide databases/users from normal postgres user
Next
From: Tom Lane
Date:
Subject: Re: reindex vs. drop index , create index