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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "emilu(at)encs(dot)concordia(dot)ca" <emilu(at)encs(dot)concordia(dot)ca>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
Date: 2017-11-24 06:28:30
Message-ID: CAKFQuwaf=KY4ZXdQKVfp+XQ_oPQCt0t4t2+-pTxEqKAe7axkng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday, November 23, 2017, Emi <emilu(at)encs(dot)concordia(dot)ca> wrote:

>
> Tried:
> psql -h db1 -U u1 -d d1 -c "\copy t1 to test.csv with CSV ENCODING
> 'UTF8' "
> Got: \copy: parse error at "encoding"
>
>
You are mixing obsolete and non-obsolete syntax. The current
syntax requires parentheses around the with options and all options written
as key-value pairs.

David J.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi 2017-11-24 14:47:01 Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
Previous Message Emi 2017-11-23 18:57:52 Re: psql -c "\copy table to test.csv with CSV" - french character is wrong