Re: psql and named pipes

* Alvaro Herrera <alvherre@commandprompt.com> [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,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.