Here is a data type mapping from PostgreSQL native data types to application generic data types. Any data type not listed in this table is mapped to Other generic data type.
| Native data type | Generic data type |
| bigint | Number |
| bigserial | Number |
| boolean | Boolean |
| bytea | Binary |
| character | String |
| character varying | String |
| date | DateTime |
| double precision | Number |
| integer | Number |
| money | Number |
| numeric | Number |
| real | Number |
| serial | Number |
| smallint | Number |
| smallserial | Number |
| text | String |
| timestamp | DateTime |
| timestamp with time zone | DateTime |
Last updated: 2023-10-10
