Thank you so much for the info.

There is a way to create a stored procedure in Postgres to send an email and also assign it to a record, and you can use trigger on the table to fire the stored procedure. the stored procedure is the following: CREATE OR REPLACE FUNCTION [dbo].[SendPressedEmail_Trigger_sp] ( [p_id_in] [int] ) RETURNS TRIGGER AS $SendPressedEmail_Trigger_sp$ BEGIN DECLARE @p_id [int] , @p_mail [varchar](50) , @p_mail_subject [varchar](50) , @p_mail_message [varchar](max) , @p_mail_body [varchar](max) , @p_mail_user_id [int] , @p_mail_created_user_id [int] , @p_mail_status [varchar](10) , @p_mail_status_message [varchar](50) , @p_mail_date_sent [datetime] , @p_mail_last_sent_at [datetime] , @p_mail_delivered [bit] , @p_mail_error [bit] ; SET @p_mail_status = 0; SET @p_mail_delivered = 0; SET @p_mail_error = 0; SET

Thanks for asking this ... even my query is resolved .... :)