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