postgresql数据库 实现id 自增

创建单列自增行

CREATE SEQUENCE upms_log_id_seq START 10;

创建数据库sql:

重点行

• "ar_id" int4 DEFAULT nextval('upms_log_id_seq'::regclass) NOT NULL,

/*
Navicat PGSQL Data Transfer

Source Server         : 本地库PostgreSql
Source Server Version : 100700
Source Host           : localhost:5432
Source Database       : postgres
Source Schema         : public

Target Server Type    : PGSQL
Target Server Version : 100700
File Encoding         : 65001

Date: 2019-04-23 18:09:26
*/


-- ----------------------------
-- Table structure for alarm_rules
-- ----------------------------
DROP TABLE IF EXISTS "public"."alarm_rules";
CREATE TABLE "public"."alarm_rules" (
"ar_id" int4 DEFAULT nextval('upms_log_id_seq'::regclass) NOT NULL,
"bc_id" int4 NOT NULL,
"rule_name" varchar(100) COLLATE "default",
"rule_type" varchar(100) COLLATE "default",
"parameter_0" varchar(100) COLLATE "default",
"parameter_1" varchar(100) COLLATE "default"
)
WITH (OIDS=FALSE)

;
COMMENT ON TABLE "public"."alarm_rules" IS 'ss表';
COMMENT ON COLUMN "public"."alarm_rules"."ar_id" IS '唯一id';
COMMENT ON COLUMN "public"."alarm_rules"."bc_id" IS '关联基础表id';
COMMENT ON COLUMN "public"."alarm_rules"."rule_name" IS '名称';
COMMENT ON COLUMN "public"."alarm_rules"."rule_type" IS '类型';
COMMENT ON COLUMN "public"."alarm_rules"."parameter_0" IS '参数';
COMMENT ON COLUMN "public"."alarm_rules"."parameter_1" IS '参数';

-- ----------------------------
-- Alter Sequences Owned By 
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table alarm_rules
-- ----------------------------
ALTER TABLE "public"."alarm_rules" ADD PRIMARY KEY ("ar_id");