复制表

CREATE TABLE "dm_epm"."d_enterprise_operation_indicators_month_cc_copy" (

  "name_project" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,

  "department_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,

  "type_project" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,

  "create_time" timestamp(6) NOT NULL DEFAULT now(),

  "line_no" int4,

  "apply_month" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,

  CONSTRAINT "d_enterprise_operation_indicators_month_cc_copy_pkey" PRIMARY KEY ("department_name", "name_project", "type_project", "apply_month", "create_time")

)DISTRIBUTE BY replication

;

ALTER TABLE "dm_epm"."d_enterprise_operation_indicators_month_cc_copy" 

  OWNER TO "devuser";

COMMENT ON TABLE "dm_epm"."d_enterprise_operation_indicators_month_cc_copy" IS '所属企业经营状况-月维表';

INSERT INTO d_enterprise_operation_indicators_month_cc_copy SELECT * from d_enterprise_operation_indicators_month