psql copy script

From: <Aniko(dot)Badzong(at)swisscom(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: psql copy script
Date: 2006-01-25 16:32:25
Message-ID: E502FDA6FE0C5A4BB4EFA4250A1E049001DBE049@sxmbx51.corproot.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yantao Shi 2006-01-25 16:53:46 Re: psql copy script
Previous Message John Jensen 2006-01-25 09:58:09 Re: Where is my bottleneck?