Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
"David G. Johnston" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAKFQuwaf=KY4ZXdQKVfp+XQ_oPQCt0t4t2+-pTxEqKAe7axkng@mail.gmail.com> |
On Thursday, November 23, 2017, Emi <[email protected]> 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.