Another way is to put a little shim between the fifo and psql. Here's one I
quickly whipped up in perl (code stolen shamelessly from the perl man
pages). To run in background, invoke thus
  ( perl myperlfile myfifo | psql gatabase ) &

The only wrinkle I found was that I had to send the \q twice to make it
quit - I have no idea why.

use strict;

my $curpos;
my $fifofile = shift || usage();


open(FILE,$fifofile) || die $!;
for (;;)
    for ($curpos = tell(FILE); $_ = <FILE>; $curpos = tell(FILE))
         print $_;
    seek(FILE, $curpos, 0);

sub usage
    print STDERR "usage: ",$0," fifofile\n";
    exit 1;

----- Original Message ----- 
From: "Matthew T. O'Connor" <[EMAIL PROTECTED]>
To: "James Pye" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:44 PM
Subject: Re: [HACKERS] persistant psql feature suggestion

> 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
> > 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:
> 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])

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to