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

Emi <[email protected]>
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.