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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
