utf8 COPY DELIMITER?

Поиск
Список
Период
Сортировка
От Mark Dilger
Тема utf8 COPY DELIMITER?
Дата
Msg-id f02ulk$2r3u$1@news.hub.org
обсуждение исходный текст
Ответы Re: utf8 COPY DELIMITER?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
The \COPY command rejects multibyte delimiters.  Is this intentional 
behavior?

Here is an example of the behavior:

pgsql@compaq ~ $ touch foo
pgsql@compaq ~ $ psql -p 5555
Welcome to psql 8.3devel, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands
\gor terminate with semicolon to execute query       \q to quit
 

pgsql=# create table foo (a integer);
CREATE TABLE
pgsql=# \copy foo from foo delimiter '標'
ERROR:  COPY delimiter must be a single character
\copy: ERROR:  COPY delimiter must be a single character



If your email/news reader doesn't render that properly, I'm using a 
pictogram character for the delimiter.

I checked out a new copy of the sources from cvs this morning.  It 
behaves the same way on 8.2.3.

mark


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Unhelpful debug tools on OS X :-(
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: utf8 COPY DELIMITER?