PostgreSQL Data Types

PostgreSQL Data Type | 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 |