Re: question about \encoding option of psql

On 12/14/11 10:12 PM, Xiaobo Gu wrote:
> I know \encoding is a meta command to set client encoding on psql
> prompt, but how can I set it inside the psql command line which will
> be called inside shell scripts,
>
> psql -h 192.168.72.7 -U gpadmin -w -d miner_demo -c"\copy demo.store
> to 'd:\store.csv' with csv header"
>
>
> How can I set the encoding for the export csv file?

one thing that comes to mind, put the \encoding and \copy commands in a
.sql file, and invoke it with psql .... -f file.sql



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast