Python package to set triggers and listen to events from a Postgres database and receive the payload as JSON.
pgnotify will call the specified callback function whenever there is any event from the table(s) specified in the JSON.
pgnotify can be installed using pip
pip install pgnotify
Here's an example on how to use pgnotify to specify the tables on which triggers are to be setup and how to pass callback function to receive the JSON payload.
Sample payload is shown below :
{'table': 'users', 'schema': 'public', 'op': 'INSERT', 'data': {'username': 21}, 'timestamp': 1527701379.0146108}
which includes
- The table on which the change was made on
- The schema type
- The operation
- The data change
- The timestamp of the event
MIT