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