Online
v0.9.0
Tables
dialect_data_types 367 records
| dialect | type_name | type_template | datada_type | is_default | supports_length | supports_precision | supports_scale | default_length | default_precision | default_scale | max_length | description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| POSTGRESQL | box | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Rectangular box |
| POSTGRESQL | path | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Open or closed path |
| POSTGRESQL | polygon | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Closed geometric path |
| POSTGRESQL | circle | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Circle |
| POSTGRESQL | geometry | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | PostGIS geometry type |
| POSTGRESQL | geography | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | PostGIS geography type |
| POSTGRESQL | _int4 | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Integer array |
| POSTGRESQL | _text | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text array |
| POSTGRESQL | _varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Varchar array |
| POSTGRESQL | xml | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | XML data |
| POSTGRESQL | bit | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Fixed-length bit string |
| POSTGRESQL | bit varying | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length bit string |
| POSTGRESQL | tsvector | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text search document |
| POSTGRESQL | tsquery | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text search query |
| POSTGRESQL | int4range | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of integer |
| POSTGRESQL | int8range | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of bigint |
| POSTGRESQL | numrange | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of numeric |
| POSTGRESQL | tsrange | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of timestamp without time zone |
| POSTGRESQL | tstzrange | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of timestamp with time zone |
| POSTGRESQL | daterange | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Range of date |
| EXCEL | text | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text/string cell |
| EXCEL | number | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Numeric cell (integer or decimal) |
| EXCEL | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Boolean value (TRUE/FALSE) |
| EXCEL | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date value |
| EXCEL | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time value |
| EXCEL | datetime | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date and time value |
| EXCEL | currency | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Currency formatted number |
| EXCEL | percentage | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Percentage formatted number |
| EXCEL | formula | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Cell containing a formula |
| EXCEL | error | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Error value (#N/A, #REF!, etc.) |
| CSV | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text string value |
| CSV | integer | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Whole number |
| CSV | decimal | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Decimal number |
| CSV | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Floating-point number |
| CSV | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Boolean value (true/false, 1/0, yes/no) |
| CSV | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date value (YYYY-MM-DD) |
| CSV | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time value (HH:MM:SS) |
| CSV | datetime | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date and time value (ISO 8601) |
| CSV | base64 | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Base64-encoded binary data |
| TERADATA | byteint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 1-byte signed integer (-128 to 127) |
| TERADATA | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte signed integer |
| TERADATA | integer | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | decimal | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | double precision | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | number | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Oracle-compatible NUMBER type |
| TERADATA | char | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | long varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length character data up to 64000 |