On Thu, Mar 31, 2011 at 18:56, Steve Clark <sclark@xxxxxxxxxxxxx> wrote: > Hi List, > > I am having a problem trying to do the following: > ssh postgres@xxxxxxxxxxxxxx '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@xxxxxxxxxxxxxx '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 postgres@xxxxxxxxxxxxxx '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 postgres@xxxxxxxxxxxxxx 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
