Explore the different datatype to catalog datatype mappings available for the datasource.
Advanced connectivity bundle mapping
The mapping from datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used. For configuration details, refer Advanced connector bundle.
| Datatype | Catalog datatype |
|---|---|
| bigint | integer |
| bigserial | integer |
| bit varying | blob |
| character varying | string |
| date | date |
| double precision | double |
| inet | string |
| time with time zone | time |
| time | time |
| timestamp | datetime |
| timestamp with time zone | datetime |
| tsquery | string |
| tsvector | string |
| txid_snapshot | string |
| uuid | string |
| xml | string |
| box | string |
| bytea | blob |
| BOOLEAN | boolean |
| CHARACTER | string |
| character varying | string |
| cidr | string |
| circle | string |
| Interval | string |
| INTEGER | integer |
| Json | string |
| jsonb | string |
| line | string |
| lseg | string |
| macaddr | string |
| macaddr8 | string |
| money | string |
| numeric | decimal |
| path | string |
| pg_lsn | string |
| pg_snapshot | string |
| point | string |
| polygon | string |
| real | double |
| smallint | integer |
| smallserial | integer |
| serial | integer |
| text | string |