Horton

Re: COPY doesn't works when containing ' ' or ' ' characters on db

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jaume Teixi <teixi@6tems.com>
Cc: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org, "Richard T. Robino" <rickspam@wavedivision.com>, Stefan Huber <schweinsaug@crosswinds.net>
Date: 2001-02-27T03:16:35Z
Lists: pgsql-hackers 
Jaume Teixi <teixi@6tems.com> writes:
> I finally percated that when data contains '' or '' it's impossible to
> parse trought:

> COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g

> it causes:

> SELECT edicion FROM products;
>      edicion     
> -----------------
>  Espaa|Nacional <-------puts on the same cell either there's an '|' in
> the middle!!!

Very odd.  What LOCALE and multibyte encodings are you using, if any?
This seems like it must be a multibyte issue, but I can't guess what.

Also, which Postgres version are you running?  If you said, I missed it.

			regards, tom lane