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

[GENERAL] question about \encoding option of psql

2011-12-14 Thread Xiaobo Gu
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"\copy demo.store to 'd:\store.csv' with csv header" How can I set the en

Re: [GENERAL] Question about encoding

2006-11-30 Thread Daniel Serodio
Richard Broersma Jr wrote: > > Is it possible to configure PostgreSQL so that a " LIKE 'a' " query > > will match a 'á' value, ie, make it accent-insensitive ? > > I forgot this was possible using regular expressions. I don't think it is > possible using the LIKE > syntax. What a pity, I've found

Re: [GENERAL] Question about encoding

2006-11-28 Thread Albe Laurenz
> Is it possible to configure PostgreSQL so that a " LIKE 'a' " query > will match a 'á' value, ie, make it accent-insensitive ? Maybe something like this can help you: test=> select to_ascii(convert('tête-à-tête français', 'LATIN9'),'LATIN9'); to_ascii -- tete-

Re: [GENERAL] Question about encoding

2006-11-27 Thread Richard Broersma Jr
> Is it possible to configure PostgreSQL so that a " LIKE 'a' " query > will match a 'á' value, ie, make it accent-insensitive ? I forgot this was possible using regular expressions. I don't think it is possible using the LIKE syntax. if you use something like: select * from yourtable where you

[GENERAL] Question about encoding

2006-11-27 Thread Daniel Serodio
Is it possible to configure PostgreSQL so that a " LIKE 'a' " query will match a 'á' value, ie, make it accent-insensitive ? Thanks in advance, Daniel Serodio ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http: