foreign keys & pg_dump - Mailing list pgsql-novice

From Chr. Rossmanith
Subject foreign keys & pg_dump
Date
Msg-id 3A36533E.3845BF22@neuro.ma.uni-heidelberg.de
Whole thread Raw
List pgsql-novice
Hi,

I've set up a little data base with postgres 7.0.3 and now I'm playing
with pg_dump. As far as I can see, foreign keys aren't stored in the
output of pg_dump and thus can't be restored. Maybe someone out there
can give me a hint what I'm doing wrong, because I'd expect everything
should be contained in a backup of the data base. I used the following
command:

pg_dump -d myDB > /tmp/db.txt



Thank you,

Christina Rossmanith


pgsql-novice by date:

Previous
From: brentr@hdc.govt.nz
Date:
Subject: Unload of Data
Next
From: Tom Lane
Date:
Subject: Re: processing results from INTERSECT, UNION or EXCEPT