DB with bytea types reload problem

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: DB with bytea types reload problem
Date: 2003-12-16 17:52:59
Message-ID: 20031216175259.GB3422@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am using 7.3.2

I've made a mistake and saved a database like this

pg_dump -a -d <db> > out.sql

...instead of using a binary output format, which I guess I need. I
can't reload the db due to some thumbnail images which are stored as
bytea.

psql: \i out.sql

Causes multiple errors, such as:

psql:out.sql:505: invalid command \N
psql:out.sql:505: invalid command \

The sql dump file has lines starting something like this for the photo
table:
1 500 375 h \\377\\330\\377\\340\\000\\020JFIF\\000\\001\\001\\001\\000H\\000H\\000\\000\\377\\341\\023>Exif\\000\\000MM\\000*\\000\\000\\000\\010\\000\\012\\00....

Is there any way I can retrieve the image data?

Thanks,
Rory
--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2003-12-16 17:57:27 Reload bytea [was Re: Picture with Postgres and Delphi]
Previous Message Jason Hihn 2003-12-16 17:36:05 Re: Authentication Question