GaussDB->PostgreSQL

BOOLEAN

BOOLEAN

Yes

SMALLINT

SMALLINT

Yes

TINYINT

SMALLINT

Yes

INTEGER

INTEGER

Yes

BIGINT

BIGINT

Yes

NUMERIC

NUMERIC

Yes

NUMBER

NUMERIC

Yes

REAL

REAL

Yes

DOUBLE PRECISION

DOUBLE PRECISION

Yes

SMALLSERIAL

SMALLSERIAL

Yes

SERIAL

SERIAL

Yes

BIGSERIAL

BIGSERIAL

Yes

LARGESERIAL

BIGSERIAL

Yes. Data overflow may occur because the value range of the LARGESERIAL data type supported by GaussDB is greater than the maximum value of BIGSERIAL for the SERIAL data type supported by PostgreSQL.

CHARACTER(n)

CHARACTER(n)

Yes

CHAR(n)

CHAR(n)

Yes

NCHAR(n)

CHAR(n)

Yes

CHARACTER VARYING(n)

CHARACTER VARYING(n)

Yes

VARCHAR(n)

VARCHAR(n)

Yes

VARCHAR2(n)

VARCHAR(n)

Yes

NVARCHAR2(n)

VARCHAR(n)

Yes

NVARCHAR(n)

VARCHAR(n)

Yes

TEXT

TEXT

Yes

CLOB

TEXT

Yes

DATE

DATE

Yes

TIME [(p)] [WITHOUT TIME ZONE]

TIME [(p)] [WITHOUT TIME ZONE]

Yes

TIME [(p)] [WITH TIME ZONE]

TIME [(p)] [WITH TIME ZONE]

Yes

TIMESTAMP[(p)] [WITHOUT TIME ZONE]

TIMESTAMP[(p)] [WITHOUT TIME ZONE]

Yes

TIMESTAMP[(p)][WITH TIME ZONE]

TIMESTAMP[(p)][WITH TIME ZONE]

Yes

INTERVAL DAY (l) TO SECOND (p)

INTERVAL[fields][(p)]

Yes

INTERVAL[fields][(p)]

INTERVAL[fields][(p)]

Yes

BLOB

BYTEA

Yes

RAW

BYTEA

Yes. RAW data supported by GaussDB, a hexadecimal string, will be written into the BYTEA column supported by PostgreSQL. The length in bytes of a RAW value in GaussDB is twice that of a BYTEA value in PostgreSQL. GaussDB and PostgreSQL use the same bytecode and hexadecimal notation.

BYTEA

BYTEA

Yes

BIT(n)

BIT(n)

Yes

BIT VARYING(n)

BIT VARYING(n)

Yes

POINT

POINT

Yes

LSEG

LSEG

Yes

BOX

BOX

Yes

PATH

PATH

Yes

POLYGON

POLYGON

Yes

CIRCLE

CIRCLE

Yes

CIDR

CIDR

Yes

INET

INET

Yes

MACADDR

MACADDR

Yes

TSVECTOR

TSVECTOR

Yes

TSQUERY

TSQUERY

Yes

UUID

UUID

Yes

INTEGER[]

INTEGER[]

Yes

TEXT[][]

TEXT[][]

Yes

JSON

JSON

Yes

MONEY

MONEY

Yes

TINYINT UNSIGNED

SMALLINT

Yes

SMALLINT UNSIGNED

INT

Yes

INTEGER UNSIGNED

BIGINT

Yes

BIGINT UNSIGNED

NUMERIC

Yes

SMALLDATETIME

-

No

RELTIME

-

No

ABSTIME

-

No

TID

-

No

XID

-

No

CID

-

No

OID

-

No