-
Notifications
You must be signed in to change notification settings - Fork 4
asotolongo/pgsmtp
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Function to send mail by smtp in 9.3+ Edited & Tested for Postgresql 16.0 ====================================== This PostgreSQL extension implements a functions to send mail and attach by smtp using plpython IMPORTANT: There're bugs in the existing version, please contact to me. This extentsion in only executable by admid user, because use untrusted language plpython Building and install -------- Install postgresql-plpython:sudo apt-get install postgresql-plpython-9.x (where x >=3) Run make install In postgresql execute: CREATE EXTENSION plpython3u; create extension pgsmtp; Example ------- #insert data(user, smtpserver,port,password) about the sender user un into table pgsmtp.user_smtp_data, is required to send mail INSERT INTO pgsmtp.user_smtp_data VALUES ('asoto@gmail.com','smtp.gmail.com',587,'mypass') #sending mail pgsmtp.pg_smtp_mail(sender, receiver, cc,topic,text) with cc select pgsmtp.pg_smtp_mail('asoto@gmail.com','asoto@gmail.com',array['mail@mail.com','other@mail.com'],'Test mail','Mail from postgres using pgsmtp :D'); #sending mail pgsmtp.pg_smtp_mail(sender, receiver, cc,topic,text) without cc select pgsmtp.pg_smtp_mail('asoto@gmail.com','asoto@gmail.com',array[''],'Test mail','Mail from postgres using pgsmtp :D'); #sending mail pgsmtp.pg_smtp_mail_attach(sender, receiver, cc,topic,text,attach) with attach select pgsmtp.pg_smtp_mail_attach('asoto@gmail.com','asoto@gmail.com',array[''],'Test mail','Mail from postgres using pgsmtp :D',array['/tmp/adjunto.txt']); -- Anthony R. Sotolongo leon asotolongo@gmail.com
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published