pg admin III and primary keys (for backup/restore)

From: Assad Jarrahian <jarraa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg admin III and primary keys (for backup/restore)
Date: 2006-01-04 22:12:18
Message-ID: 4bd3e1480601041412m9f2832dud3613347a26fea3e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Environment: Deployed on Debian. Test and Development on Windows.
Using pg_admin III and Postgresql 8.1 (both test and development).

I want to backup Development and restore it in test and vice-versa.

So when I do a backup of the db (in PGAdmin III), it backs it up. But
when I restore it, all primary key information is gone and no data is
in the tables.

Any help would be much appreciated. Thanks.

-assad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sven Willenberger 2006-01-04 22:39:35 Re: insert serial numbers
Previous Message Stephan Szabo 2006-01-04 20:08:30 Re: "REFERENCES" and UNIQUE