本文共 7257 字，大约阅读时间需要 24 分钟。

CREATE TABLE "public"."sys_user_copy1_new" (  "id" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_id" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_name" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_tel" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_account" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_password" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "user_job" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "org_id" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,  "createtime" timestamp(6) NOT NULL,  "updatetime" timestamp(6) NOT NULL,  "status" varchar(32) COLLATE "pg_catalog"."default",  "Isdel" int4 NOT NULL,  "Isuse" varchar(64) COLLATE "pg_catalog"."default",	  "aaa" varchar(255) COLLATE "pg_catalog"."default",  "bbb" varchar(255) COLLATE "pg_catalog"."default",  "userphoto" varchar(255) COLLATE "pg_catalog"."default");ALTER TABLE "public"."sys_user_copy1_new"   OWNER TO "postgres";COMMENT ON COLUMN "public"."sys_user_copy1_new"."id" IS '主键';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_id" IS '用户Id';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_name" IS '用户名';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_tel" IS '电话';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_account" IS '用户账号';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_password" IS '用户密码';COMMENT ON COLUMN "public"."sys_user_copy1_new"."user_job" IS '用户职位';COMMENT ON COLUMN "public"."sys_user_copy1"."org_id" IS '所属组织机构Id';COMMENT ON COLUMN "public"."sys_user_copy1_new"."createtime" IS '创建时间';COMMENT ON COLUMN "public"."sys_user_copy1_new"."updatetime" IS '修改时间';COMMENT ON COLUMN "public"."sys_user_copy1_new"."status" IS '状态码';COMMENT ON COLUMN "public"."sys_user_copy1_new"."Isdel" IS '是否删除;0,未删除;1,删除';COMMENT ON COLUMN "public"."sys_user_copy1_new"."Isuse" IS '是否启用,0,未启用,1启用';COMMENT ON COLUMN "public"."sys_user_copy1_new"."aaa" IS 'aaa';COMMENT ON COLUMN "public"."sys_user_copy1_new"."bbb" IS 'aaa';COMMENT ON COLUMN "public"."sys_user_copy1_new"."userphoto" IS '用户头像';COMMENT ON TABLE "public"."sys_user_copy1_new" IS '用户表';-- ------------------------------ 1.1、从表sys_workface插入表sys_workface_new数据-- ----------------------------INSERT INTO "public"."sys_user_copy1_new"	("id" ,  "user_id" ,  "user_name" ,  "user_tel" ,  "user_account" ,  "user_password" ,  "user_job" ,  "org_id" ,  "createtime" ,  "updatetime" ,  "status" ,  "Isdel",  "Isuse" ,  "userphoto" ) 	select		"id" ,		"user_id" ,		"user_name" ,		"user_tel" ,		"user_account" ,		"user_password" ,		"user_job" ,		"org_id" ,		"createtime" ,		"updatetime" ,		"status" ,		"Isdel",		"Isuse" ,		"userphoto"	FROM "public"."sys_user_copy1";-- ------------------------------ 1.2、将表sys_workface名称改为表 sys_workface_bak--      将表sys_workface_new名称改为表 sys_workface-- ----------------------------	alter table sys_user_copy1 rename to sys_user_copy1_bak;	--先改原表的名字alter table sys_user_copy1_new rename to sys_user_copy1; 	--再改新表的名字

这辈子坚持与不坚持都不可怕，怕的是独自走在坚持的道路上。

第二种方式

CREATE TABLE "public"."sys_mine_pressure_data_new" (  "id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,  "namespace" varchar(255) COLLATE "pg_catalog"."default",  "workface_code" varchar COLLATE "pg_catalog"."default" NOT NULL,  "init_strength_ratio" float4,  "init_no_standard_scu" text COLLATE "pg_catalog"."default",  "init_strength_average" float4,  "strength_over_ratio" float4,  "strength_over_suc" text COLLATE "pg_catalog"."default",  "supplement_scu" text COLLATE "pg_catalog"."default",  "supplement_no_standard_scu" text COLLATE "pg_catalog"."default",  "min_pressure" text COLLATE "pg_catalog"."default",  "max_pressure" text COLLATE "pg_catalog"."default",  "pressure_scu" text COLLATE "pg_catalog"."default",  "shear_pass_scu" text COLLATE "pg_catalog"."default",  "init_standard_count" int4,  "asq_count" int4,  "record_start_time" timestamp(6),  "record_end_time" timestamp(6),  "manual" int4 DEFAULT 0,  "data_type" varchar COLLATE "pg_catalog"."default",  "extend" varchar COLLATE "pg_catalog"."default",  CONSTRAINT "sys_mine_pressure_data_new_pk" PRIMARY KEY ("id"));ALTER TABLE "public"."sys_mine_pressure_data_new"   OWNER TO "postgres";COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."id" IS '主键';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."namespace" IS '矿井公司';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."workface_code" IS '工作面编码';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."init_strength_ratio" IS '初撑力达标率';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."init_no_standard_scu" IS '初撑力不达标支架和次数，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."init_strength_average" IS '平均初撑力';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."strength_over_ratio" IS '压力超限率';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."strength_over_suc" IS '超限支架和次数，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."supplement_scu" IS '补压支架和次数，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."supplement_no_standard_scu" IS '补压不达标支架和次数，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."min_pressure" IS '支架和最小压力，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."max_pressure" IS '支架和最大压力，map的json格式';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."pressure_scu" IS '采煤机经过的支架，逗号分隔去重，计算压力超限率';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."shear_pass_scu" IS '采煤机经过的支架，逗号分隔去重，计算压力超限率';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."init_standard_count" IS '初撑力达标次数';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."asq_count" IS '降移升循环总次数';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."record_start_time" IS '记录开始时间';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."record_end_time" IS '记录结束时间';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."data_type" IS '数据类型：生产班、日、月、年类型';COMMENT ON COLUMN "public"."sys_mine_pressure_data_new"."extend" IS '扩展字段，可存放json数据';INSERT INTO "public"."sys_mine_pressure_data_new"	( "id" ,  "namespace",  "workface_code" ,  "init_strength_ratio" ,  "init_no_standard_scu" ,  "init_strength_average" ,  "strength_over_ratio" ,  "strength_over_suc",  "supplement_scu",  "supplement_no_standard_scu" ,  "min_pressure" ,  "max_pressure" ,  "shear_pass_scu",  "init_standard_count",  "asq_count" ,  "record_start_time",  "record_end_time",  "manual" ,  "data_type" ,  "extend" ) 	select		"id" ,  "namespace",  "workface_code" ,  "init_strength_ratio" ,  "init_no_standard_scu" ,  "init_strength_average" ,  "strength_over_ratio" ,  "strength_over_suc",  "supplement_scu",  "supplement_no_standard_scu" ,  "min_pressure" ,  "max_pressure" ,  "shear_pass_scu",  "init_standard_count",  "asq_count" ,  "record_start_time",  "record_end_time",  "manual" ,  "data_type" ,  "extend" 	FROM "public"."sys_mine_pressure_data";-- ------------------------------ 1.2、将表sys_workface名称改为表 sys_workface_bak--      将表sys_workface_new名称改为表 sys_workface-- ----------------------------	-- alter table sys_mine_pressure_data rename to sys_mine_pressure_data_bak;	--先改原表的名字-- alter table sys_mine_pressure_data_new rename to sys_mine_pressure_data; 	--再改新表的名字--

转载地址：http://fkoai.baihongyu.com/