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

I had exactley the same problem and solved in the very same way.
A lot slower and alot faster but it worked.

Tried with changing encoding and so on, but -d made my difference.

Is there any way to go around this? I dont have to be forced to take backup
with -d if our database gets bigger.. if avoidable.

> -----Original Message-----
> From: Rainer Mager [mailto:rmager(at)vgkk(dot)com]
> Sent: den 1 mars 2001 00:02
> To: Tom Lane; pgsql-admin(at)postgresql(dot)org
> Subject: RE: [ADMIN] 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？|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
>
###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/