Re: [GENERAL] question about \encoding option of psql

2011-12-16 Thread Adrian Klaver
On Thursday, December 15, 2011 10:33:03 pm Xiaobo Gu wrote: > Hi Adrian, > > I am on the Windows platform, how should I paste the command line. I don't use Windows enough to be sure but: http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/echo.mspx?mfr=true So open a

Re: [GENERAL] question about \encoding option of psql

2011-12-15 Thread Xiaobo Gu
Hi Adrian, I am on the Windows platform, how should I paste the command line. Regards, Xiaobo Gu On Thu, Dec 15, 2011 at 10:44 PM, Adrian Klaver wrote: > On Wednesday, December 14, 2011 10:12:40 pm Xiaobo Gu wrote: >> Hi, >> >> I know \encoding is a meta command to set client encoding on psql

Re: [GENERAL] question about \encoding option of psql

2011-12-15 Thread Adrian Klaver
On Wednesday, December 14, 2011 10:12:40 pm Xiaobo Gu wrote: > Hi, > > 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

Re: [GENERAL] question about \encoding option of psql

2011-12-15 Thread Guillaume Lelarge
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

Re: [GENERAL] question about \encoding option of psql

2011-12-14 Thread John R Pierce
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' wit