Re: DB with bytea types reload problem

Rory Campbell-Lange wrote:
>     pg_dump -a -d <db> > out.sql

 From this:

 > The sql dump file has lines starting something like this for the photo
 > table:
 >     1   500 375 h \\377\\330\\377\\340...

it doesn't look to me like you actually ran that command. The -d says
you should have INSERT statements, but you seem to have copy out data.
Try doing:

COPY tablename FROM 'out.sql';

or some variation thereof.

Joe