建表sql
CREATE TABLE all_flink_types (
test_INT2 INT2
,test_SMALLSERIAL SMALLSERIAL
,test_SERIAL2 SERIAL2
,test_INTEGER INTEGER
,test_SERIAL SERIAL
,test_BIGINT BIGINT
,test_BIGSERIAL BIGSERIAL
,test_REAL REAL
,test_FLOAT4 FLOAT4
,test_FLOAT8 FLOAT8
,test_DOUBLE_PRECISION DOUBLE PRECISION
,test_NUMERIC NUMERIC(15,3)
,test_DECIMAL DECIMAL(15,3)
,test_BOOLEAN BOOLEAN
,test_DATE DATE
,test_TIME TIME(3)
,test_TIMESTAMP TIMESTAMP(3)
,test_CHAR CHAR(250)
,test_CHARACTER CHARACTER(250)
,test_VARCHAR VARCHAR(250)
,test_CHARACTER_VARYING CHARACTER VARYING(250)
,test_TEXT TEXT
,test_BYTEA BYTEA
,test_ARRAY4 integer ARRAY[4]
,test_ARRAY4_4 text[4][4]
,primary key (test_INTEGER)
);
insert语句
INSERT INTO all_flink_types (
test_INT2,
test_SMALLSERIAL,
test_SERIAL2,
test_INTEGER,
test_SERIAL,
test_BIGINT,
test_BIGSERIAL