utf8 COPY DELIMITER?

From: Mark Dilger <pgsql(at)markdilger(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: utf8 COPY DELIMITER?
Date: 2007-04-17 16:01:58
Message-ID: f02ulk$2r3u$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The \COPY command rejects multibyte delimiters. Is this intentional
behavior?

Here is an example of the behavior:

pgsql(at)compaq ~ $ touch foo
pgsql(at)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
\g or 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2007-04-17 16:28:18 Re: utf8 COPY DELIMITER?
Previous Message Tom Lane 2007-04-17 15:58:55 Unhelpful debug tools on OS X :-(