psql -c "\copy table to test.csv with CSV" - french character iswrong

Поиск
Список
Период
Сортировка
От Emi
Тема psql -c "\copy table to test.csv with CSV" - french character iswrong
Дата
Msg-id 7c6b8218-bdde-1c0a-2cbf-f817b37c2a2f@encs.concordia.ca
обсуждение исходный текст
Ответы Re: psql -c "\copy table to test.csv with CSV" - french character iswrong  (Pierre Chevalier Géologue <pierrechevaliergeol@free.fr>)
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
Hello,

Tried to run:   psql -h db1 -U u1   -d d1 -c "\copy t1 to test.csv with CSV"

Problem:   French characters are not shown correctly.


Tried:   psql -h db1 -U u1   -d d1 -c "\copy t1 to test.csv with CSV ENCODING 
'UTF8' "   Got: \copy: parse error at "encoding"

Can you help how to copy french characters correctly into csv file please?

Thanks a lot.
-- 
. French characters show correctly in t1
. Client/server encoding: UTF8
. Cannot use super user: postgre
. Version 8.3.18

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

Предыдущее
От: Hector Vass
Дата:
Сообщение: Re: How to use COPY command with jsonb datatype ?
Следующее
От: Pierre Chevalier Géologue
Дата:
Сообщение: Re: psql -c "\copy table to test.csv with CSV" - french character iswrong