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
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 |