* Alvaro Herrera <[EMAIL PROTECTED]> [080327 12:58]: > I was under the impression that I could start a "psql -f pipe" and then > feed it commands through the pipe using echo, and expect it to hang from > one command to the next. Of course, this doesn't work -- my guess is > that echo sends an EOF after the line I send, so psql sees the EOF in > the pipe and terminates. > > Does anyone have an idea how to go about this? I was expecting to be > able to drive two psql sessions in parallel in a shell script -- sort of > poor man's concurrent psql :-(
I've had to use:
while (true); do cat pipe; done | psql
The trick is that pipes "EOF"s everytime the cleint closes it. (Not
strictly true, but it appears that way to basic read()ers).
You can see a more compilcated setup I use to echo commands to a pipe
going to a psql here:
http://www.highrise.ca/aidan/postgresql/watchsql
--
Aidan Van Dyk Create like a god,
[EMAIL PROTECTED] command like a king,
http://www.highrise.ca/ work like a slave.
signature.asc
Description: Digital signature
