psql copy script - Mailing list pgsql-admin

From
Subject psql copy script
Date
Msg-id E502FDA6FE0C5A4BB4EFA4250A1E049001DBE049@sxmbx51.corproot.net
Whole thread Raw
Responses Re: psql copy script  (Yantao Shi <y.shi@larc.nasa.gov>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: "John Jensen"
Date:
Subject: Re: Where is my bottleneck?
Next
From: Yantao Shi
Date:
Subject: Re: psql copy script