Updated on 2023-07-03 GMT+08:00

PostgreSQL->GaussDB

Table 1 Data type mapping

Data Type (PostgreSQL)

Data Type (GaussDB)

Whether to Support Mapping

SMALLINT

SMALLINT

Yes

INTEGER

INTEGER

Yes

BIGINT

BIGINT

Yes

INTEGER

INTEGER

Yes

REAL

REAL

Yes

DOUBLE PRECISION

DOUBLE PRECISION

Yes

NUMERIC

NUMERIC

Yes

CHARACTER VARYING

CHARACTER VARYING

Yes

CHARACTER

CHARACTER

Yes

BIT

BIT

Yes

BIT VARYING

BIT VARYING

Yes

BOOLEAN

BOOLEAN

Yes

BYTEA

BYTEA

Yes

TEXT

TEXT

Yes

TIME WITHOUT TIME ZONE

TIME WITHOUT TIME ZONE

Yes

TIME WITH TIME ZONE

TIME WITH TIME ZONE

Yes

TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP WITHOUT TIME ZONE

Yes

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH TIME ZONE

Yes

INTERVAL

INTERVAL

Yes

CIDR

CIDR

Yes

PATH

PATH

Yes

BOX

BOX

Yes

LSEG

LSEG

Yes

MACADDR

MACADDR

Yes

POINT

POINT

Yes

POLYGON

POLYGON

Yes

INET

INET

Yes

TSQUERY

TSQUERY

Yes

TSVECTOR

TSVECTOR

Yes

UUID

UUID

Yes