copy from problem

Поиск
Список
Период
Сортировка
От Mark Watson
Тема copy from problem
Дата
Msg-id 89F27524F0C64622B8970CEB3C3ED385@Gateway
обсуждение исходный текст
Ответы Re: copy from problem  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: copy from problem  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: Root user commands
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: copy from problem