Click here to Skip to main content
13,141,576 members (50,677 online)
Click here to Skip to main content
Add your own
alternative version

Stats

3.1K views
80 downloads
4 bookmarked
Posted 14 Sep 2017

A PostgreSQL Notification Example

, 14 Sep 2017
Rate this:
Please Sign up or sign in to vote.
PostgreSQL notifications Windows Forms application

ntroduction

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:

History

  • Version 1.0

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

RickZeeland
Software Developer
Netherlands Netherlands
Software developer in the Netherlands, currently working on Video Surveillance applications.
Experience: C#, C++, VB, ASP, SQL Server, PostgreSQL.
It all started with Black&White, no not the whiskey but the Sinclair ZX81 followed by several Atari's and PC's. The journey continues ...

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.170915.1 | Last Updated 14 Sep 2017
Article Copyright 2017 by RickZeeland
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid