Hi List, I am having a problem trying to do the following: ssh postgres@192.168.198.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@192.168.198.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.cl...@netwolves.com http://www.netwolves.com
