Ozeki 10 SMS Gateway
PostgreSQL Installation PostgreSQL Installation | Configure Database User Configure Database User

Send SMS from PostgreSQL (part 2/4)
Create Database Tables

In this video series you can see how to connect Ozeki SMS Gateway to a PostgreSQL database server for SMS messaging. This video shows how to create the proper database table structure by using the GUI of your PostgreSQL database server.

Video content
1. Connect to PostgreSQL
2. Create User in PostgreSQL
3. Copy CREATE TABLE statements
Start the video

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.

Connect to the PostgreSQL server
Figure 1 - Connect to the PostgreSQL server by using the password of the superuser

CREATE TABLE statements to use on your PostgreSQL server

CREATE TABLE ozekimessagein
(
id serial,
sender varchar(30),
receiver varchar(30),
msg varchar(160),
senttime varchar(100),
receivedtime varchar(100),
operator varchar(100),
msgtype varchar(160),
reference varchar(100)
);

CREATE TABLE ozekimessageout
(
id serial,
sender varchar(30),
receiver varchar(30),
msg varchar(160),
senttime varchar(100),
receivedtime varchar(100),
reference varchar(100),
status varchar(20),
operator varchar(100),
errormsg varchar(250),
msgtype varchar(160)
);
Figure 2 - Copy CREATE TABLE statements

Copy CREATE TABLE statements from Figure 2
Figure 3 - Copy CREATE TABLE statements from Figure 2

Run CREATE TABLE statements on the database
Figure 4 - Paste CREATE TABLE statements and run them on the PostgreSQL database server  

Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Developers guide > SMS from or to Database > PostgreSQL > Create Database
Legal | Privacy | Terms of use | 5771
34.204.187.106 | 92.118.27.157 | Login