From: | Steve Clark <sclark(at)netwolves(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | 7.4 quoting |
Date: | 2011-03-31 16:56:45 |
Message-ID: | 4D94B24D.2020509@netwolves.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi List,
I am having a problem trying to do the following:
ssh postgres(at)192(dot)168(dot)198(dot)93 'psql -Atc "select a.interface, a.source_ip,a.dest_ip from kernel_gre a, ospfd_interface b where a.interface = b.interface and config ilike '%cost 50%';" config.db'
bash turns it into this:
ssh postgres(at)192(dot)168(dot)198(dot)93 'psql -Atc "select a.interface, a.source_ip,a.dest_ip from kernel_gre a, ospfd_interface b where a.interface = b.interface and config ilike %cost' '50%;" config.db'
I tried various things using \' or '' or ''' but none work.
I have even tried exchanging the outer " with ' and the inner "select to 'select but still no success.
Any ideas?
With 8.x databases I use \$\$%cost 50%\$\$ which work great.
--
Stephen Clark
*NetWolves*
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve(dot)clark(at)netwolves(dot)com
http://www.netwolves.com
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2011-03-31 16:58:48 | Re: [HACKERS] Date conversion using day of week |
Previous Message | Jerry Sievers | 2011-03-31 16:41:27 | Re: stack depth limit exceeded |