Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group