| 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: | Whole Thread | Raw Message | 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
| 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 ? |
| 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 |