Updated on 2024-01-18 GMT+08:00

From PostgreSQL to GaussDB

Source Data Type

Converted Data Type

Conversion Configuration

SMALLINT

SMALLINT

-

INTEGER

INTEGER

-

BIGINT

BIGINT

-

INTEGER

INTEGER

-

REAL

REAL

-

DOUBLE PRECISION

DOUBLE PRECISION

-

NUMERIC

NUMERIC

-

CHARACTER VARYING

CHARACTER VARYING

Character datatype conversion

If you select Extended character data type char/varchar length, the storage of characters converted by DRS and UGO is equivalent.

CHARACTER

CHARACTER

Character datatype conversion

If you select Extended character data type char/varchar length, the storage of characters converted by DRS and UGO is equivalent.

BIT

BIT

-

BIT VARYING

BIT VARYING

-

BOOLEAN

BOOLEAN

-

BYTEA

BYTEA

-

TEXT

TEXT

-

TIME WITHOUT TIME ZONE

TIME WITHOUT TIME ZONE

-

TIME WITH TIME ZONE

TIME WITH TIME ZONE

-

TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP WITHOUT TIME ZONE

-

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH TIME ZONE

-

INTERVAL

INTERVAL

-

CIDR

CIDR

-

PATH

PATH

-

BOX

BOX

-

LSEG

LSEG

-

MACADDR

MACADDR

-

POINT

POINT

-

POLYGON

POLYGON

-

INET

INET

-

TSQUERY

TSQUERY

-

TSVECTOR

TSVECTOR

-

UUID

UUID

-

JSON

JSON

-

JSONB

JSONB

-

For details about the configuration items, see Editing the Configurations During Migration from PostgreSQL to GaussDB.