Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group