| 支持类型列表 | 转成ZCBUS类型列表 |
|---|---|
| smallint/int2 | INTEGER |
| integer/int4 | INTEGER |
| bigint/int8 | BIGINTEGER |
| decimal | DECIMAL |
| numeric | DECIMAL |
| real | FLOAT4 |
| double precision | FLOAT8 |
| smallserial | INTEGER |
| serial | INTEGER |
| bigserial | BIGINTEGER |
| money | FLOAT8 |
| character varying(n)， varchar(n) | VARCHAR |
| character(n)， char(n) | CHAR |
| text | TEXT |
| bytea | BLOB |
| timestamp [ (p) ] [ without time zone ] | TIMESTAMP |
| timestamp [ (p) ] with time zone | TIMESTAMP |
| date | DATE |
| time [ (p) ] [ without time zone ] | TIME |
| time [ (p) ] with time zone | TIMESTAMP |
| interval [ fields ] [ (p) ] | BIGINTEGER |
| boolean | INTEGER |
| point | JSON |
| line | JSON |
| lseg | JSON |
| box | JSON |
| path | JSON |
| path | JSON |
| polygon | JSON |
| circle | JSON |
| cidr | VARCHAR |
| inet | VARCHAR |
| macaddr | VARCHAR |
| tsvector | |
| tsquery | VARCHAR |
| UUID | VARCHAR |
| XML | TEXT |
| JSON | JSON |
文档更新时间: 2021-01-27 06:43 作者：阿力
