Send SMS from PostgreSQL (part 4/4)
Send Test Message

This is the last video in this video series which shows how to connect Ozeki SMS Gateway to a PostgreSQL database server for SMS messaging. See how to insert a simple row into the proper table, so Ozeki SMS Gateway can automatically send SMS messages to mobile phones.

Video content
1. Insert message into database
2. Send Test message

Look at the upcoming screenshots to thoroughly examine the final stage, which is SMS sending. You can start the whole process by INSERT-ing the SMS into the database (Figure 2).

open database user
Figure 1 - Open Database user

INSERT message record (example):
INSERT INTO ozekimessageout (receiver,msg,status) values ('+36201234567','Hello World','Send');
Figure 2 - Copy INSERT statement

paste insert statement to postgresqls database table
Figure 3 - Paste INSERT statement to PostgreSQL's database table

the sent folder shows that your message have been sent by ozeki sms gateway
Figure 4 - The Database User's sent folder shows that your message has been sent by Ozeki SMS Gateway

More information