From: <Aniko(dot)Badzong(at)swisscom(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject:
Date: 2006-01-26 08:52:33
Message-ID: E502FDA6FE0C5A4BB4EFA4250A1E049001DBE04B@sxmbx51.corproot.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I have tried it yesterday to escaoe the double qutoes and I get the
error:

[test] su - postgres -c "echo \"copy test from '/data/log/bla';"\" |
psql logdb"
Unmatched ".

somehow does not want to work.

RE: [SQL] psql in the command line
from: Russell Simpkins [russellsimpkins(at)hotmail(dot)com]
if in fact this works: echo "copy test from '/data/log/bla';" | psql
logdb
then you probably want to write it like this:
su - postgres -c "echo \"copy test from '/data/log/bla';\"|>psql logdb"
so that you escape the double quotes.

Responses

  • Re: at 2006-01-26 12:30:11 from Alvaro Herrera
  • Re: at 2006-01-26 15:06:29 from Tom Lane

Browse pgsql-admin by date

  From Date Subject
Next Message John Jensen 2006-01-26 08:57:08 Re: Where is my bottleneck?
Previous Message Frank L. Parks 2006-01-26 04:17:29 Re: Missing Databases