To create a solution to send text messages from PostgreSQL we will need 13 minutes. This article provides directions and the necessary information to help you complete this procedure efficiently.
Maybe the greatest benefit of this PostgreSQL solution is that all you have to do is perform some basic configuration and you will be ready to send sms in a short time.
This solution is based on Ozeki SMS Gateway, so you can take advantage of that fact that it offers excellent logging capabilities, which means you can track down errors quickly.
We assume your are familiar with the basics of how mobile text messaging works.
You will be presented some valuable information and well structured step by step instructions.
We hope you will enjoy reading it.
Video content
1. Connect to PostgreSQL
2. Create User in PostgreSQL
3. Copy CREATE TABLE statements
How to create the proper database table (Video tutorial)
In this vide, you will learn how to create a correctly working database table using the PostgreSQL GUI called pgadmin.
The video will start with opening pgadmin and will end with the working database table.
You will learn how to configure the table during creation and how to setup the permissions in pgadmin.
The video is only a little longer then 2 minutes and it features all the steps you need to take in a detailed form.
You will have no problem following the tutorial.
Please
scroll down to copy the SQL statements
(
Figure 2-3
) used in the video. If you have created the database in PostgreSQL,
you can
jump to the next video
.
Launch pgadmin
On
Figure 1
, you can see the icon you need to look for called pgadmin.
Click it
to launch the app where you can start setting up the database structure and
start connecting to the PostgreSQL server.
The following SQL commands can be used to create a user called 'ozekiuser', with a password of 'ozekipass'.
This is a PostgreSQL user account. You can use this user account to connecto to the ozeki database.
On
Figure 7
, you can see that how you can copy the provided code.
This code will build the database so the
Ozeki SMS Gateway
could work with it.
Right-click the highlighted code and choose the
copy
option.
Paste the code
To build your database, you need to
paste the copied code
into the
query editor
section of pgadmin.
Paste it and run the code.
It will build a usable database that you can work with. You can see the pasted code on
Figure 8
.
Send SMS from postgres
SMS database definition
Connect postgres database to the SMS gateway
Send test SMS from postgres SQL server
