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

I haven't been following this thread very carefully but I just remembered a
similar problem we had that is probably related. We did a dump from a UTF-8
db containind English, Japanese, and Korean data. When the dump was done in
the default mode (e.g., via COPY statements) then we could no restore it. It
would die on certain characters. We then tried dumping in with -nd flags.
This fixed the problem for us although the restore is a lot slower.

--Rainer

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Tuesday, February 27, 2001 12:17 PM
> To: Jaume Teixi
> Cc: pgsql-hackers(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org; Richard T.
> Robino; Stefan Huber
> Subject: Re: [ADMIN] COPY doesn't works when containing ' ' or ' '
> characters on db
>
>
> 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
> > -----------------
> > Espa痺蜿釶辞頤黶辣繻繪纈蒹鱚蜴
迚粐跂　帙鴒粐葹模蛋姪鈔磔釿閼蜴苴鱚阨皷鈑蜀銷壽蜩繞逑蜍蜚矼磔齠碯竅逾苺纉癆糟齒蜒倆齡苒纉纈皷闔鱚阨鉗鈑黶蜆迚齠繖
鱚艨鰾鵺闕瘤