Groups > comp.databases.postgresql > #892

how to use NOTIFY to publish previous and new record

Newsgroups	comp.databases.postgresql
Date	2020-12-25 17:27 -0800
Message-ID	<4cd43e08-e7d9-4360-8180-8ad54df0b572n@googlegroups.com> (permalink)
Subject	how to use NOTIFY to publish previous and new record
From	Alexander Mills <alexander.d.mills@gmail.com>

Show all headers | View raw

Can anyone describe how I might be able to use NOTIFY with postgres, to send both the previous record and the new record, for an update to a table record?

something like:

NOTIFY <namespace>
{prev: {}}
{new: {}}

some example with code (node.js or golang ideal) would really help me so much, never used NOTIFY before and find examples only to be obtuse,

-alex

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

how to use NOTIFY to publish previous and new record Alexander Mills <alexander.d.mills@gmail.com> - 2020-12-25 17:27 -0800
  Re: how to use NOTIFY to publish previous and new record Christian Barthel <bch@online.de> - 2020-12-26 21:50 +0100

csiph-web