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

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Cc: "Richard T(dot) Robino" <rickspam(at)wavedivision(dot)com>, Stefan Huber <schweinsaug(at)crosswinds(dot)net>
Subject: COPY doesn't works when containing '' or '' characters on db
Date: 2001-02-26 13:28:58
Message-ID: 20010226142858.2f1fcee8.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message si 2001-02-26 15:04:50 indexing
Previous Message Jaume Teixi 2001-02-26 10:48:12 Re: NOSUCCESS: m$ access -> psql howto ?

Browse pgsql-hackers by date

  From Date Subject
Next Message kdebisschop 2001-02-26 14:08:35 Re: Monitor status
Previous Message Zeugswetter Andreas SB 2001-02-26 13:08:01 AW: Re: http access to ftp.postgresql.org files