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:50 5: invalid command \N
psql:out.sql:50 5: 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\\020 JFIF\\000\\001\ \001\\001\\000H \\000H\\000\\00 0\\377\\341\\02 3>Exif\\000\\00 0MM\\000*\\000\ \000\\000\\010\ \000\\012\\00.. ..
Is there any way I can retrieve the image data?
Thanks,
Rory
--
Rory Campbell-Lange
<ro**@campbel l-lange.net>
<www.campbell-lange.net>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org