Re: Create Action for psql when NOTIFY Recieved

On Tue, Aug 29, 2017 at 10:21 AM, Daniel Verite <daniel(at)manitou-mail(dot)org>
wrote:

> Jerry Regan wrote:
>
> > I think I could justify the effort to ‘script’ psql. I’m not so sure I
> can
> > justify the effort to write a standalone program.
>
> As a hack around psql, you could have a script that feeds psql
> with "SELECT 1" from time to time and capture only the
> notifications output:
>
> (echo "listen foo;"; while true; do echo "select 1;"; sleep 1; done) | \
> psql | grep notification
>
> When another session issues NOTIFY foo, 'bar'
> that output filtered by the above command is, for example:
>
> Asynchronous notification "foo" with payload "bar" received from
> server process with PID 20033.
>
> which just needs to be piped into another step that runs your custom
> action.
>

​Sounds like a job for "expect".
https://www.tcl.tk/man/expect5.31/expect.1.html​

>
>
> Best regards,
> --
> Daniel Vérité
>

--
Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may
cause stress to those with hippopotomonstrosesquipedaliophobia.

Maranatha! <><
John McKown