On Fri, 2003-06-27 at 03:21, James Pye wrote: > Greets, > > Just a thought for a psql enhancement, afiak, it is not easily possible for > persistent connections to a database in a shell script.. > The ability for psql to remain in the background reading from stdin and > writing to stdout until explicitly killed. More specifically, so a shell scriptor > can have "persistent" connections to the database by calling psql once(leaving it in > the bg), and redirecting stdio through a fifo(mkfifo)(sending queries by echo > > fifo, and fetching results by cat fifo). > When I have tried this in the past it will read the query, execute it, and > exit when the results are cat'd from the fifo.
Not sure if it's exactly what you are looking for, nor how well it's still maintained, but.... I believe there is a took out there called pgbash which is a modified version of bash that understands database queries natively. I think it's just what you are looking for. Check out: http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html Looks like it was updated for 7.3 Matthew ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])