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

From: Emi <emilu(at)encs(dot)concordia(dot)ca>
To: Pierre Chevalier Géologue <pierrechevaliergeol(at)free(dot)fr>, pgsql-sql(at)postgresql(dot)org
Subject: Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
Date: 2017-11-23 18:57:52
Message-ID: de7c7cc0-3710-12db-5bd1-35f0fa8b7006@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> sql2csv "SELECT DISTINCT opid, year FROM public.field_observations
> ORDER BY year LIMIT 10" > /tmp/rien.csv
>
Ok. Will use stdout then.

Thanks.
--
psql -c "copy t1 to STDOUT with CSV" >! test.csv

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2017-11-24 06:28:30 Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
Previous Message Pierre Chevalier Géologue 2017-11-23 18:24:39 Re: psql -c "\copy table to test.csv with CSV" - french character is wrong