On 03/31/2011 02:06 PM, Arjen Nienhuis wrote:
On Thu, Mar 31, 2011 at 20:05, Arjen Nienhuis<[email protected]> wrote:
On Thu, Mar 31, 2011 at 18:56, Steve Clark<[email protected]> wrote:
Hi List,
I am having a problem trying to do the following:
ssh [email protected] '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 [email protected] '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'
try:
ssh [email protected] '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'
which bash turns into:
ssh [email protected] 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
Argh!
I mean:
ssh [email protected] 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
Great! that did it thanks a bunch!!!
Regards,
Steve
--
Stephen Clark
*NetWolves*
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: [email protected]
http://www.netwolves.com
