From: | "Mark Watson" <mark(dot)watson(at)jurisconcept(dot)ca> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | copy from problem |
Date: | 2010-12-22 20:34:58 |
Message-ID: | 89F27524F0C64622B8970CEB3C3ED385@Gateway |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2010-12-22 21:16:47 | Re: copy from problem |
Previous Message | Leif Biberg Kristensen | 2010-12-22 19:39:48 | Re: Root user commands |