pgsql 建数据库注意事项
在用navacat建好表之后,需要主键自增的时候,把字段建好之后,可以使用下面的sql来建立主键自增。
ALTER TABLE "public"."chart_sql" ADD PRIMARY KEY ("id");
DROP SEQUENCE IF EXISTS "chart_sql_id_seq";
CREATE SEQUENCE chart_sql_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
alter table chart_sql alter column id set default nextval('chart_sql_id_seq');
建好之后,导出sql 给别人安装运行sql会报错,这时候需要
DROP SEQUENCE IF EXISTS "chart_sql_id_seq";
CREATE SEQUENCE "chart_sql_id_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
先定义自增名称,导出sql如下:
DROP SEQUENCE IF EXISTS "chart_sql_id_seq";
CREATE SEQUENCE "chart_sql_id_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
DROP TABLE IF EXISTS "public"."chart_sql";
CREATE TABLE "public"."chart_sql" (
"id" int4 DEFAULT nextval('chart_sql_id_seq'::regclass) NOT NULL,
"code" varchar(50) COLLATE "default",
"name" varchar(50) COLLATE "default",
"code_sql" text COLLATE "default",
"create_time" timestamp(6),
"create_by" varchar(30) COLLATE "default",
"update_time" timestamp(6),
"update_by" varchar(30) COLLATE "default"
)
WITH (OIDS=FALSE);
ALTER TABLE "public"."chart_sql" ADD PRIMARY KEY ("id");
这样别人运行sql就不会出错,建成的表就是主键自增的了。。。