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@hotmail.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.