读取
PostgreSQL 类型 | 内部类型 |
- | TINYINT |
SMALLINT，INT2，SMALLSERIAL，SERIAL2 | SMALLINT |
INTEGER，SERIAL | INT |
BIGINT，BGSERIAL | BIGINT |
- | DECIMAL(20, 0) |
REAL，FLOAT4 | FLOAT |
FLOAT8，DOUBLE PRECISION | DOUBLE |
NUMERIC(p, s)，DECIMAL(p, s) | DECIMAL(p, s) |
BOOLEAN | BOOLEAN |
DATE | DATE |
TIME [(p)][WITHOUT TIMEZONE] | TIME [(p)][WITHOUT TIMEZONE] |
TIMESTAMP [(p)]WITHOUT TIMEZONE | TIMESTAMP [(p)][WITHOUT TIMEZONE] |
CHAR(n)，CHARACTER(n)，VARCHAR(n)，CHARACTER ，VARYING(n)，TEXT | STRING |
BYTEA | BYTES |
写入
内部类型 | PostgreSQL 类型 |
TINYINT | - |
SMALLINT | SMALLINT，INT2，SMALLSERIAL，SERIAL2 |
INT | INTEGER，SERIAL |
BIGINT | BIGINT，BIGSERIAL |
DECIMAL(20, 0) | - |
FLOAT | REAL，FLOAT4 |
DOUBLE | FLOAT8，DOUBLE PRECISION |
DECIMAL(p, s) | NUMERIC(p, s)，DECIMAL(p, s) |
BOOLEAN | BOOLEAN |
DATE | DATE |
TIME [(p)][WITHOUT TIMEZONE] | TIME [(p)][WITHOUT TIMEZONE] |
TIMESTAMP [(p)][WITHOUT TIMEZONE] | TIMESTAMP [(p)]WITHOUT TIMEZONE |
STRING | CHAR(n)，CHARACTER(n)，VARCHAR(n)，CHARACTER VARYING(n)，TEXT |
BYTES | BYTEA |