PostgreSQLソースデータ型 | PostgreSQLターゲットデータ型 |
|---|---|
bigint | bigint |
bit varying(precision), 1 <= p <= 83886080 | bytea |
bit(precision), 1 <= p <= 83886080 | bytea |
boolean | boolean |
box | bytea |
character varying(size), 1 <= s <= 10485760 | character varying(size), 1 <= s <= 10485760 |
character(size), 1 <= s <= 10485760 | character varying(size), 1 <= s <= 10485760 |
cidr | cidr |
circle | bytea |
date | date |
daterange | daterange |
double precision | double precision |
inet | inet |
int4range | int4range |
int8range | int8range |
integer | integer |
json | json |
jsonb | jsonb |
line | bytea |
lseg | bytea |
macaddr | macaddr |
macaddr8 | macaddr8 |
money | money |
numeric | numeric |
numeric(p,s), 1 <= p <= 1000, 0 <= s <= 1000 | numeric(p,s), 1 <= p <= 1000, 0 <= s <= 1000 |
numrange | numrange |
path | bytea |
point | bytea |
polygon | bytea |
real | real |
smallint | smallint |
time(precision) with time zone, 0 <= p <= 6 | time(precision) with time zone, 0 <= p <= 6 |
time(precision) without time zone, 0 <= p <= 6 | time(precision) without time zone, 0 <= p <= 6 |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp(precision) with time zone, 0 <= p <= 6 |
timestamp(precision) without time zone, 0 <= p <= 6 | timestamp(precision) without time zone, 0 <= p <= 6 |
tsrange | tsrange |
tstzrange | tstzrange |
uuid | uuid |
xml | xml |