Alvaro Herrera wrote: > [EMAIL PROTECTED] 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\''"
Or, preferably: $ echo "copy test from '/data/log/bla';" | sudo -u postgres psql logdb HTH, Owen ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
