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