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

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: SOLVED: COPY doesn't works when containing ' ' or ' ' characters on db
Date: 2001-02-27 09:19:12
Message-ID: 20010227101912.62338293.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On Mon, 26 Feb 2001 22:16:35 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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ña|Nacional <-------puts on the same cell either there's an '|'
in
> > the middle!!!

I finally, thanks to Oliver Elphick,

managed to create database with:
CREATE DATABASE "demo" WITH ENCODING = 'SQL_ASCII'

and data was imported OK, great, thanks!

In response to

Responses

  • log files at 2001-05-04 05:16:39 from Rainer Mager

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Duffy 2001-02-27 15:00:03 Re: indexing
Previous Message Tom Lane 2001-02-27 03:16:35 Re: COPY doesn't works when containing ' ' or ' ' characters on db

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2001-02-27 09:55:04 Re: Idea for reducing planning time
Previous Message Tatsuo Ishii 2001-02-27 08:45:29 Re: SunOS4