Hi,
I'm trying to use the COPY .. FROM system with some data which includes
binary values. They aren't large, but they include invalid UTF8 bytes,
so I'm storing them into a BYTEA field.
However I get errors when I try to do this..
CREATE TABLE foo (id SERIAL PRIMARY KEY, bar BYTEA);
COPY foo (bar) FROM STDIN;
Test\xff\x0\x9Again
\.
The error given is:
ERROR: invalid byte sequence for encoding "UTF8": 0xff
CONTEXT: COPY foo, line 1: "Test\xff\x0\x9Again"
As far as I can tell, I'm obeying the instructions about escaping here:
http://www.postgresql.org/docs/current/static/sql-copy.html
I'm on version 9.1.5 of PostgreSQL.
Thanks,
Toby