JsChen2Casiku commented on issue #9032:
URL: https://github.com/apache/seatunnel/issues/9032#issuecomment-2768399464
> Could you please provide table ddl and example data?
CREATE TABLE "daos"."user_source_1w" (
"id" int8 NOT NULL,
"name" text COLLATE "pg_catalog"."default",
"gender" text COLLATE "pg_catalog"."default",
"age" int4,
"code" text COLLATE "pg_catalog"."default",
"skill" text COLLATE "pg_catalog"."default",
"phone" text COLLATE "pg_catalog"."default",
"email" text COLLATE "pg_catalog"."default",
"birthday" date,
"create_time" timestamp(6),
CONSTRAINT "user_source_1w_123_pkey" PRIMARY KEY ("id")
)
;
ALTER TABLE "daos"."user_source_1w"
OWNER TO "postgres";
COMMENT ON COLUMN "daos"."user_source_1w"."id" IS 'id';
COMMENT ON COLUMN "daos"."user_source_1w"."name" IS '姓名';
COMMENT ON COLUMN "daos"."user_source_1w"."gender" IS '性别';
COMMENT ON COLUMN "daos"."user_source_1w"."age" IS '年龄';
COMMENT ON COLUMN "daos"."user_source_1w"."code" IS '编码';
COMMENT ON COLUMN "daos"."user_source_1w"."skill" IS '技能';
COMMENT ON COLUMN "daos"."user_source_1w"."phone" IS '电话';
COMMENT ON COLUMN "daos"."user_source_1w"."email" IS '邮箱';
COMMENT ON COLUMN "daos"."user_source_1w"."birthday" IS '生日';
COMMENT ON COLUMN "daos"."user_source_1w"."create_time" IS '创建时间';
Example Data:
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (1, '梁致远', 'M',
87, 'mlxWcdKgyJ', '01mUoljD11', '(161) 312 3229', '[email protected]',
'2024-03-26', '2004-08-21 22:21:15');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (2, '曹杰宏', 'M',
90, 'VjhgUwbWoX', '32OQjeXgou', '141-9731-3355', '[email protected]',
'2012-11-04', '2023-06-15 13:04:35');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (3, '潘睿', 'M', 31,
'8YT83aveOm', 'YOwuoR16D3', '194-5270-8722', '[email protected]',
'2019-12-06', '2019-09-24 21:31:08');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (4, '潘晓明', 'M',
42, 'aStdjH4RW4', 'HvrSW2CLAl', '3-6203-8642', '[email protected]',
'2009-01-17', '2015-03-09 20:17:25');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (5, '汤睿', 'M', 0,
'mDtrvkw6Dg', '9M7DcinONH', '52-350-0481', '[email protected]', '2003-10-11',
'2014-02-16 05:56:57');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (6, '常岚', 'F', 18,
'y9ikjLd3KI', 'o70ky7F55b', '170-1217-2110', '[email protected]', '2020-05-08',
'2002-05-27 05:32:15');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (7, '陆宇宁', 'M',
73, 'JurdHU5gvK', 'N8gyud3bMp', '7918 650377', '[email protected]',
'2024-04-13', '2015-04-12 21:45:15');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (8, '杨嘉伦', 'M',
11, 'HtjdUqBvW0', '7ogYxKjGe4', '330-421-0280', '[email protected]',
'2013-10-31', '2007-10-04 21:51:29');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (9, '宋宇宁', 'M',
54, 'FN2EuLajgA', 'NUbqfqT9uV', '174-2556-0893', '[email protected]',
'2002-10-30', '2006-05-03 09:39:52');
INSERT INTO "daos"."user_source_1w" ("id", "name", "gender", "age", "code",
"skill", "phone", "email", "birthday", "create_time") VALUES (10, '邹致远', 'M',
2, 'FAAg4RVb29', 'wuUIjM2FAK', '212-768-2393', '[email protected]',
'2017-01-06', '2019-12-16 12:58:31');
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
