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