Обсуждение: psql copy script
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
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 > >