Products
Ozeki 10
Apps
Chat
SMS Gateway
Quick Start Guide
SMS with Client Software
HTTP API
SMS from/to Database
MSSQL Express
Oracle SMS
MySQL SMS
PostgreSQL
PostgreSQL Installation
Create Database
Configure Database User
Test Message
SAP SQL Anywhere
Microsoft Access
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
System Database
Robot Controller
Softphone
PBX
Connections
Installation guide
Terms and Definitions
HTTP API
SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Installer
Technology
Company


Ozeki 10 - SMS Gateway server software
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 > Products > Ozeki 10 > Apps > SMS Gateway > SMS from/to Database > PostgreSQL > Create Database
Legal | Privacy policy | Terms of use
Page: 5771 | Login | 35.173.47.43