65.9K
CodeProject is changing. Read more.
Home

A PostgreSQL Notification Example

starIconstarIconstarIconstarIconstarIcon

5.00/5 (14 votes)

Sep 14, 2017

CPOL

1 min read

viewsIcon

43315

downloadIcon

2866

PostgreSQL notifications Windows Forms application

Introduction

This is a fully fledged PostgreSQL notifications Windows Forms application created with Visual Studio 2013.

There is also an updated version for VS2019 which uses Npgsql 4.1.5.

When searching 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 the old version with PostgreSQL 9.5 and the NpgSql 2.1.3 driver.

The updated version was tested with PostgreSQL 10.14 and NpgSql 4.1.5.

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:

There is also a portable PostgreSQL version, I don't like the newest versions as they tend to be bigger and don't have PgAdminIII included with them, so my favourite remains version 9.4.5 which is only a 10 MB download.

You can download it from the link provided on top, or from:

History

  • V 1.0 Old version
  • V 2.0 New version for NpgSql 4.1.5