读取
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 |