foreign keys & pg_dump

From: "Chr(dot) Rossmanith" <cr(at)neuro(dot)ma(dot)uni-heidelberg(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: foreign keys & pg_dump
Date: 2000-12-12 16:33:03
Message-ID: 3A36533E.3845BF22@neuro.ma.uni-heidelberg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Albert REINER 2000-12-12 17:21:58 Re: Unload of Data
Previous Message Robert B. Easter 2000-12-12 15:20:52 Re: ConnectDBStart() error