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

Jaume Teixi <teixi@6tems.com>

From: Jaume Teixi <teixi@6tems.com>
To: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org
Cc: "Richard T. Robino" <rickspam@wavedivision.com>, Stefan Huber <schweinsaug@crosswinds.net>
Date: 2001-02-26T13:28:58Z
Lists: pgsql-hackers
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!!!


but changing 'ñ' for n

SELECT edicion FROM products;
     edicion     
-----------------
 Espana <---------------it separates cells ok


so what's my solution for a text to COPY containing such characters? 


best regards,
jaume