|
PostgreSQL |
SQL Data Type |
Length |
Description |
|---|---|---|---|
|
Binary (Text) |
CHAR |
-1 |
|
|
CONNXStore Timestamp |
TIMESTAMP |
8 |
|
|
CONNXStore Date |
DATE |
4 |
|
|
CONNXStore Time |
TIME |
8 |
|
|
Numeric |
Integer |
|
|
|
PostgreSQL Numeric (BE) -> Decimal |
DECIMAL |
-1 |
|
|
PostgreSQL Numeric (7.4+) -> Decimal |
DECIMAL |
-1 |
|
|
PostgreSQL Numeric (7.4+ BE) -> Decimal |
DECIMAL |
-1 |
|
|
Text -> Currency |
CURRENCY |
-1 |
|