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