Explore the different asset types and datatype to catalog datatype mappings available for the datasource.
Advanced connectivity bundle
The asset types supported for PostgreSQL using advanced connectivity bundle are:
DB Association, DB Attribute, DB Calculated Attribute, DB Calculated Measure, DB Calculation View, DB Check Constraint, DB Condition, DB Filter, DB Foreign Key, DB Function, DB Index, DB Index Member, DB Input Parameter, DB Operation, DB Output Column, DB Parameter, DB Partition Column, DB Primary Key, DB Result Attribute, DB Sequence, DB Stage, DB Stored Procedure, DB Stream, DB Task, DB Temporary Table, DB Trigger, DB Type, DB Unique ConstraintMapping
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 |