Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY doesn't works when containing ' ' or ' ' characters on db - Mailing list pgsql-admin

From Tom Lane
Subject Re: COPY doesn't works when containing ' ' or ' ' characters on db
Date
Msg-id 27748.983243795@sss.pgh.pa.us
Whole thread Raw
In response to COPY doesn't works when containing 'ñ' or 'à' characters on db  (Jaume Teixi <teixi@6tems.com>)
Responses Re: SOLVED: COPY doesn't works when containing ' ' or ' ' characters on db  (Jaume Teixi <teixi@6tems.com>)
Re: COPY doesn't works when containing ' ' or ' ' characters on db  ("Oliver Elphick" <olly@lfix.co.uk>)
RE: COPY doesn't works when containing ' ' or ' ' characters on db  ("Rainer Mager" <rmager@vgkk.com>)
List pgsql-admin
Tree view 
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
> -----------------
>  Espa�a|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

pgsql-admin by date:

Previous
From: Michael Davis
Date:
Subject: RE: relation does not exist
Next
From: Jaume Teixi
Date:
Subject: Re: SOLVED: COPY doesn't works when containing ' ' or ' ' characters on db