Skip site navigation (1) Skip section navigation (2)

bug with psql 8.3.3 on ubuntu

From: Viraj Kanwade <virajk(at)gslab(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug with psql 8.3.3 on ubuntu
Date: 2008-10-23 16:46:34
Message-ID: 4900AA6A.5020605@gslab.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

I have a table which has capital characters in it.

I am running the command

psql -d mydb -U usr -t -c " select val1 from ""MyTable"" where val2 = 
'abc' "
OR
psql -d mydb -U usr -t -c ' select val1 from "MyTable" where val2 = 
''abc'' '

Both work fine on my windows machine.

But when I try to run these commands on Ubuntu, I get the escaped (")/ 
(') are ignored.

The command it is interpreting is

psql -d mydb -U usr -t -c " select val1 from MyTable where val2 = 'abc' "
OR
psql -d mydb -U usr -t -c ' select val1 from "MyTable" where val2 = abc '

Hence, it wont work for me.

Why is this different behavior?

Please let me know what I should be doing to make it work on Ubuntu.

Thanks.
Regards,
Viraj


Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2008-10-23 17:35:53
Subject: Re: ftp server symlink
Previous:From: Zdenek KotalaDate: 2008-10-23 10:06:08
Subject: Re: bug in pageinspect contrib modul

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group