Postgres Pro
Downloads
Home   >   mailing lists

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

From Emi
Subject psql -c "\copy table to test.csv with CSV" - french character iswrong
Date
Msg-id 7c6b8218-bdde-1c0a-2cbf-f817b37c2a2f@encs.concordia.ca
Whole thread Raw
Responses Re: psql -c "\copy table to test.csv with CSV" - french character iswrong
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
List pgsql-sql
Tree view 
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 by date:

Previous
From: Hector Vass
Date:
Subject: Re: How to use COPY command with jsonb datatype ?
Next
From: Pierre Chevalier Géologue
Date:
Subject: Re: psql -c "\copy table to test.csv with CSV" - french character iswrong