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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
