pgsql主键自增，建表失败

CREATE TABLE "system_parameter" (
  "id" int4 NOT NULL DEFAULT nextval('system_parameter_id_seq'::regclass),
  "para_system" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "para_system_desc" varchar(1024) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "para_group" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "para_group_desc" varchar(1024) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "para_key" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "para_key_desc" varchar(1024) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "para_value" varchar(5012) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "para_value_desc" varchar(1024) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying,
  "create_date" date,
  "modify_date" date,
  "up_flag" varchar(2) COLLATE "pg_catalog"."default" NOT NULL,
  "para_latn_id" int8 NOT NULL
)
;

运行该建表语句报错，提示system_parameter不存在

解决：
要先创建system_parameter_id_seq序列

语句

CREATE SEQUENCE "system_parameter_id_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;