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

From Jaume Teixi
Subject COPY doesn't works when containing 'ñ' or 'à' characters on db
Date
Msg-id 20010226142858.2f1fcee8.teixi@6tems.com
Whole thread Raw
Responses Re: COPY doesn't works when containing ' ' or ' ' characters on db  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Jaume Teixi
Date:
Subject: Re: NOSUCCESS: m$ access -> psql howto ?
Next
From: "guard"
Date:
Subject: not use pg_dump & pg_dumpall