| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jaume Teixi <teixi(at)6tems(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, "Richard T(dot) Robino" <rickspam(at)wavedivision(dot)com>, Stefan Huber <schweinsaug(at)crosswinds(dot)net> |
| Subject: | Re: COPY doesn't works when containing ' ' or ' ' characters on db |
| Date: | 2001-02-27 03:16:35 |
| Message-ID: | 27748.983243795@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Jaume Teixi <teixi(at)6tems(dot)com> writes:
> 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
> -----------------
> Espaa|Nacional <-------puts on the same cell either there's an '|' in
> the middle!!!
Very odd. What LOCALE and multibyte encodings are you using, if any?
This seems like it must be a multibyte issue, but I can't guess what.
Also, which Postgres version are you running? If you said, I missed it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaume Teixi | 2001-02-27 09:19:12 | Re: SOLVED: COPY doesn't works when containing ' ' or ' ' characters on db |
| Previous Message | Derek Neighbors | 2001-02-26 18:46:03 | CHAR vs VARCHAR |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jamexu | 2001-02-27 03:18:34 | Re[3]: Re: [PATCHES] A patch for xlog.c |
| Previous Message | Tom Lane | 2001-02-27 03:05:52 | Re: Re[2]: Re: [PATCHES] A patch for xlog.c |