COPY FROM with BYTEA fields - escaping doesn't work

Поиск
Список
Период
Сортировка
От Toby Corkindale
Тема COPY FROM with BYTEA fields - escaping doesn't work
Дата
Msg-id 506CFB5F.4020602@strategicdata.com.au
обсуждение исходный текст
Ответы Re: COPY FROM with BYTEA fields - escaping doesn't work  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Fwd: pros and cons of two security models
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: [PL/PGSQL] column name substitution in PG8.4