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 |