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.