> I have tried it yesterday to escaoe the double qutoes and I get the
> [test] su - postgres -c "echo \"copy test from '/data/log/bla';"\" |
> psql logdb"
> Unmatched ".
You still don't fix it? I remembered yesterday that the shell doesn't
want escaped quotes inside a quoted argument, so you must quit the
quoted environment and put an escaped quote, something like
su - postgres -c "echo "\""copy test from '/data/log/bla';"\"" | pgsql logdb"
The echo-pipe is still overkill, you can do it using -c as I showed
yesterday by applying the same "trick".
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"Es filósofo el que disfruta con los enigmas" (G. Coli)
In response to
- at 2006-01-26 08:52:33 from Aniko.Badzong
pgsql-admin by date
|Next:||From: Brian A. Seklecki||Date: 2006-01-26 12:41:30|
|Subject: Re: Database Clustering|
|Previous:||From: Stef||Date: 2006-01-26 11:02:18|
|Subject: Re: FW: copy command|