Edit a dump file?

From: Andreas Schlegel <schlegelaw(at)gmx(dot)de>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Edit a dump file?
Date: 2003-01-20 20:59:39
Message-ID: 3E2C633B.1070601@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I tried to restore an old database ( "pg_restore -d wh2
wh2.pg_dump.20031011" ), but the restore failed because of a broken
relation.
The dump was created with "pg_dump -Ft wh2 | gzip >
wh2.pg_dump.20031011.gz".

The message says: "pg_restore: [archiver (db)] could not execute query:
ERROR: Relation "tcompanystate" does not exist"
Indeed the table was dropped in the meantime and the view was obviously
not corrcted.

My question is: is there change to edit the the dump and remove the
view? I tried to open it with vi. I can read a bit but not all.

Greetings,
Andreas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2003-01-20 21:02:03 Re: Writing apps for ORDBMS
Previous Message Tom Lane 2003-01-20 20:56:31 Re: readline configure error again