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

Emi <[email protected]>
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]> 
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.