Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group