Query-Sending mail from PostgresSQL

From: Ramesh Rajamanickam <rameshr(dot)bnk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Query-Sending mail from PostgresSQL
Date: 2016-02-25 03:40:57
Message-ID: CAP117R2ToWZiOszh6uUNnQffV_2N7VFVyVEx7FY=jnoB+3dEQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Brian Ghidinelli 2016-02-25 07:21:30 Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid` [WORKAROUND]
Previous Message Andres Freund 2016-02-24 21:52:21 Re: BUG #13985: Segmentation fault on PREPARE TRANSACTION