Don't you have to use a "\" in front of copy like : \copy?
I use \copy command all the time, never have any problems with it.
Yantao Shi
Aniko.Badzong@xxxxxxxxxxxx wrote:
Hi Alvaro
Thanks for the help but it does not work.
when I execute it than I get:
[test/data] su - postgres -c "psql logdb -c 'copy test from
\'/data/log/bla\''"
Unmatched '.
If I correct the error than I get the following:
[test/data] su - postgres -c "psql logdb -c 'copy test from
\'/data/log/bla'\'"
psql: warning: extra command-line argument "copy test from
\/data/log/bla\" ignored
psql: FATAL: role "-c" does not exist
Any idea why?
thx and regards
Aniko
