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 |