Supported data types
Several data types are supported for external tables.
The following table describes the supported data types for external tables.
| Data type | Example | Description |
|---|---|---|
|
byteint
smallint integer bigint |
120
0 256 1290985 |
See Integer data types. |
|
numeric
decimal |
-99.56
123.679 |
See Fixed-point data types. |
| real double precision |
-81293.35 | See Floating-point data types. |
| char (n) | salary | See Character strings. |
| varchar (n) | this is a variable string | See Character strings. |
| boolean | true | This is an ASCII string that contains one of the following values:
See BoolStyle option. |
| JSON | See Document data types | |
| date | 2002-02-04 | The date is an exact 4-byte data type. The system recognizes a range of dates that are
composed of year, month, and day. See DateStyle option. |
| time | 01:59:45 23:00:01 |
See time data type. |
| time with time zone | 01:15:33 -05 | See Time with time zone (timetz) data type. |
| timestamp | 2002-02-04 01:15:33 | See timestamp data type. |
| interval | 2 years 3 months 4 days | See Interval data types. |