Query-Sending mail from PostgresSQL - Mailing list pgsql-bugs

From Ramesh Rajamanickam
Subject Query-Sending mail from PostgresSQL
Date
Msg-id CAP117R2ToWZiOszh6uUNnQffV_2N7VFVyVEx7FY=jnoB+3dEQw@mail.gmail.com
Whole thread Raw
Responses Re: Query-Sending mail from PostgresSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Query-Sending mail from PostgresSQL  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-bugs
Hi,

We are using Postgres. Doing migration from Oracle to Postgres SQL. Now we
wanted to migrate the Sending mail operation as in oracle. Searched the
help couldn't able to find the solution.  Below is the oracle statement
used.

UTL_MAIL.send(
                sender     =>  EMAIL_DIST,
                recipients =>  EMAIL_DIST,
                cc         =>  EMAIL_DIST,
                bcc        =>  EMAIL_DIST,
                subject    =>  Load_Name ,
                message    =>  emesg
                );

Please give your suggestion how we can migrate the above statement to
Postgres.

Thanks
Ramesh Rajamanickam

pgsql-bugs by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: BUG #13985: Segmentation fault on PREPARE TRANSACTION
Next
From: syspegasus@gmail.com
Date:
Subject: BUG #13990: Postgres shutting down automatically