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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

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-2017 The PostgreSQL Global Development Group