More than one characters in DELIMITER (for COPY)

From: "L(dot) Berger" <straightfwd007(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: More than one characters in DELIMITER (for COPY)
Date: 2007-07-25 15:54:01
Message-ID: 1185378841.390804.98560@z28g2000prd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We have data where all the characters on the keyboard are used. The
data is utf-8, so all of those European characters with umlauts and
such are also used. Because of this we have {~} as the delimiter, even
{} was taken!

Now when I try to specify this delimiter in the COPY command to import
the data into a table, I get the error message that the delimiter can
only be a single character. Why this requirement? Most databases allow
importing/exporting with any delimiter I wish!

I'd appreciate some thoughts on what my options are..

Thanks!

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2007-07-25 16:32:10 Re: CentOS 4 RPMs for 8.2.4?
Previous Message Alvaro Herrera 2007-07-25 15:46:09 Re: a few questions (and doubts) about xid