Обсуждение: foreign keys & pg_dump

Поиск
Список
Период
Сортировка

foreign keys & pg_dump

От
"Chr. Rossmanith"
Дата:
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