Re: psql in the command line

Aniko(dot)Badzong(at)swisscom(dot)com wrote:

> test:/opt/pgsql# echo "copy test from '/data/log/bla';" | psql logdb
> COPY
>
> But when I try to execute it as root user I get the following error:
>
> [est/data/log] su - postgres -c "echo 'copy test from /data/log/bla;'|
> psql logdb"
> ERROR: syntax error at or near "/" at character 16
> LINE 1: copy test from /data/log/bla;

This is clearly not the same line. The quotes are not in the same
position as in the line above.

su - postgres -c "psql logdb -c 'copy test from \'data/log/bla\''"

--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Es filósofo el que disfruta con los enigmas" (G. Coli)