Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eIFG1-0006iE-Vt for pgsql-sql@arkaria.postgresql.org; Fri, 24 Nov 2017 14:47:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eIFG1-0007SL-17 for pgsql-sql@arkaria.postgresql.org; Fri, 24 Nov 2017 14:47:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eIFG0-0007SC-H1 for pgsql-sql@lists.postgresql.org; Fri, 24 Nov 2017 14:47:08 +0000 Received: from oldperseverance.encs.concordia.ca ([132.205.96.92]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eIFFw-0001yZ-GH for pgsql-sql@lists.postgresql.org; Fri, 24 Nov 2017 14:47:06 +0000 Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca [132.205.47.225]) by oldperseverance.encs.concordia.ca (envelope-from emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id vAOEl14U013342 for ; Fri, 24 Nov 2017 09:47:02 -0500 Reply-To: emilu@encs.concordia.ca Subject: Re: psql -c "\copy table to test.csv with CSV" - french character is wrong References: <7c6b8218-bdde-1c0a-2cbf-f817b37c2a2f@encs.concordia.ca> To: pgsql-sql@lists.postgresql.org From: Emi Message-ID: Date: Fri, 24 Nov 2017 09:47:01 -0500 User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------87E7FD34E5854CFE7BA19D34" X-Scanned-By: MIMEDefang 2.58 on oldperseverance.encs.concordia.ca at 2017-11-24 09:47:02 EST List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------87E7FD34E5854CFE7BA19D34 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hello, > > > Tried: > psql -c "\copy t1 to test.csv with CSV ENCODING 'UTF8' " > Got: \copy: parse error at "encoding" > > > mixing obsolete and non-obsolete syntax. requires parentheses around > with options and all options written as key-value pairs. I think you mean 9.x. My version is 8.x, and doc shows ENCODING 'encoding_name' only for 9.x. I will use stdout for 8.x. Thanks. --------------87E7FD34E5854CFE7BA19D34 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
Hello,


Tried:
   psql -c "\copy t1 to test.csv with CSV ENCODING 'UTF8' "
   Got: \copy: parse error at "encoding"


mixing obsolete and non-obsolete syntax. requires parentheses around with options and all options written as key-value pairs.
I think you mean 9.x. My version is 8.x, and doc shows ENCODING 'encoding_name' only for 9.x. I will use stdout for 8.x.

Thanks.
--------------87E7FD34E5854CFE7BA19D34--