ODBC - PostgreSQL Database

The values of the variables are saved in a PostgreSQL Database.

The variable values are saved in the following table structure.

Column name

Data type

Null permitted

Characteristic

id

bigint

no

IDENTITY(1,1)

timestamp

timestamp

no

 

name

text

no

 

ValueType="Double"

value

double precision

no

 

ValueType="Bytes"

value

BLOB

no

 

To get the functionality of an AutoID a sequence will be create at the scheme you use with the following attributes:

name:                          "mytable_ID_seq"

raise step:                  "1"

minimum:                   "1"

An AutoID is generated in the "ID" column. The value in this column is, in other words, always increased by 1. This functionality makes the sequence possible.
The "Timestamp" column stores the time at which the data record was saved.
The name of the variable is stored in the "Name" column.
The "Value" column stores the value of the variable.

E_DBColumnTypes

PostgreSQL

PLC Control

eDBColumn_BigInt

bigint

DINT

eDBColumn_Integer

integer

DINT

eDBColumn_SmallInt

smallint

INT

eDBColumn_TinyInt

smallint

INT

eDBColumn_Bit

bit

BYTE

eDBColumn_Money

money

LREAL

eDBColumn_Float

double precision

LREAL

eDBColumn_Real

real

REAL

eDBColumn_DateTime

timestamp

DT

eDBColumn_NText

text

STRING

eDBColumn_NChar

character

STRING

eDBColumn_Image

bytea

ARRAY OF BYTE

eDBColumn_NVarChar

character varying

STRING

eDBColumn_Binary

bytea

ARRAY OF BYTE

eDBColumn_VarBinary

bytea

ARRAY OF BYTE