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

persistant psql feature suggestion

From: James Pye <jwp(at)rhid(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: persistant psql feature suggestion
Date: 2003-06-27 07:21:58
Message-ID: 20030627072158.GA24757@void.ph.cox.net (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

	Just wanted to make sure nothing similar enough was already in existence, and if anyone could easily implement this. If no one wants to, I suppose I'll look into doing it if it's worth doing. :)


Cheers,

	James

Responses

pgsql-hackers by date

Next:From: Manfred KoizarDate: 2003-06-27 09:16:19
Subject: 'out of tree' compile (was: Two weeks to feature freeze)
Previous:From: Nicolas JOUANINDate: 2003-06-27 06:45:52
Subject: Re: TR: Like and =

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