This is a fully fledged PostgreSQL notifications Windows Forms application created with Visual Studio 2013.
On the internet, I only found scraps of information on how to do notification events in PostgreSQL, but not a complete working example.
Using the Code
So here it is, the only thing that needs to be present is a database, the table and triggers will be created by the application.
I tested it with PostgreSQL 9.5 and the NpgSql driver.
After pressing the <Start> button, listening starts with the PostgreSQL "
listen mynotification" command.
Notification events can be triggered from the application using the <Trigger> and <Insert row> buttons, and also by directly editing the database.
Points of Interest
More information can be found from the links below: