| 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: | Whole Thread | Raw Message | 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>
| 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 |