写入
内部类型 | Greenplum 类型 |
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 |