DM8达梦数据库:DTS数据迁移工具异构数据库数据类型映射

FLOAT4	FLOAT
FLOAT8	FLOAT
INT2	SMALLINT
INT4	INT
INT8	BIGINT
BPCHAR	CHAR
TIMETZ	TIME WITH TIME ZONE
TIMESTAMPTZ	TIMESTAMP WITH TIME ZONE
REGPROC	VARCHAR(100)
NAME	VARCHAR(100)
XID	INT
BOOL	BIT
BOOLEAN	BIT
BYTEA	BLOB
XML	TEXT
CHARACTER	VARYING VARCHAR
ABSTIME	TIMESTAMP WITH TIME ZONE
SERIAL	INT
BIGSERIAL	BIGINT
TSQUERY	TEXT
UUID	VARCHAR
CIRCLE	VARCHAR
POLYGON	TEXT
PATH	TEXT
BOX	VARCHAR
LSEG	VARCHAR
LINE	VARCHAR
POINT	VARCHAR
TSVECTOR	TEXT
BIT	BINARY
VARBIT	VARBINARY
MACADDR	VARCHAR
INET	VARCHAR
CIDR	VARCHAR
MONEY	NUMBER
INTERVAL类型	VARCHAR(100)