Data Types
This section describes the data types added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.
| Name | Data Type |
|---|---|
| Variable-length character type | VARCHAR2 and NVARCHAR2 |
| Decimal floating point type | DECIMAL |
| Double precision binary floating point type | BINARY_DOUBLE |
| Binary data type | RAW |
| Binary large object type | BLOB |
| Character large object type | CLOB |
| National character large object | NCLOB |
| Number type | NUMBER |
| Variable-length character type | NVARACHAR |
| Unicode character data type | NCHAR |
| 32-bit floating point data type | BINARY_FLOAT |
| Long integer | LONG |
| XML data type | XMLType |
| Timestamp with local time zone | TIMESTAMP WITH LOCAL TIME ZONE |
| PL/SQL integer numeric data | BINARY_INTEGER |
| PL/SQL integer numeric data | PLS_INTEGER |
Last Article: System Views
Next Article: Implicit Type Conversion
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.