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@swisscom.com 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
>
>