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