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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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