By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,327 Members | 2,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,327 IT Pros & Developers. It's quick & easy.

Can PostgreSQL initiate a message through a socket?

P: 1
I would like postgres to send a message via a socket to another machine if a certain table is updated or changed...Is this possible?

If so please guide...

I'd rather not have the c application on another machine have to continually poll for changes...

Plz help
Jan 19 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
Not sure if this is the best way to accomplish what you need, but you may consider this:

Create a rule or a trigger on insert, update and delete for your table.
From there you can call a C-function, which can do TCP/IP communication, or anything else you need.
Jan 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.