| From: | Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)com> |
|---|---|
| To: | Steve Clark <sclark(at)netwolves(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 7.4 quoting |
| Date: | 2011-03-31 18:05:19 |
| Message-ID: | AANLkTikycLLkQWhf0UykiJRPrkULc9PFi0EcWQp=xX9B@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arjen Nienhuis | 2011-03-31 18:06:48 | Re: 7.4 quoting |
| Previous Message | Brendan Jurd | 2011-03-31 17:51:07 | Re: [HACKERS] Date conversion using day of week |