On Mon, 26 Feb 2001 22:16:35 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Jaume Teixi <[EMAIL PROTECTED]> 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!
