On Wed, 2011-12-14 at 22:26 -0800, John R Pierce wrote:
> 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
>
Using the PGCLIENTENCODING environment variable might be a better
option.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com