From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Mark Watson" <mark(dot)watson(at)jurisconcept(dot)ca> |
Subject: | Re: copy from problem |
Date: | 2010-12-22 21:16:47 |
Message-ID: | 201012221316.47650.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 22 December 2010 12:34:58 pm Mark Watson wrote:
> Hello all,
> (Postgres 8.4.6 Windows)
> I am stumped as to why I cannot import this using copy from within pgadmin
> (the following table is created in an existing database with an encoding of
> WIN1252 and the Postgres server_encoding is UTF8) :
> CREATE TABLE test
> (
> col_descr text
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE test OWNER TO postgres;
> set client_encoding = 'WIN1252';
> COPY test FROM 'C:\\pgtemp\\test.txt' with delimiter as '|' csv;
> select * from test;
> --- col_descr
> -- ----------------
> -- (empty row)
>
> The file test.txt contains 1 line of 2 characters: éÉ (acute accented
> lowercase and uppercase e, hex(E9C9), valid win1252 characters.
>
> Any help would be appreciated.
> Mark
Is there anything in the database logs? Are the two characters separated by '|'?
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-12-23 06:59:16 | Re: copy from problem |
Previous Message | Mark Watson | 2010-12-22 20:34:58 | copy from problem |