Re: 7.4 quoting

On Thu, Mar 31, 2011 at 20:05, Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)com> wrote:
> On Thu, Mar 31, 2011 at 18:56, Steve Clark <sclark(at)netwolves(dot)com> wrote:
>> 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'
> try:
>
> 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'
>
> which bash turns into:
>
> 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
>

Argh!

I mean:

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