CREATE TABLE player (
player_id integer,
player_name varchar(20),
PRIMARY KEY (player_id)
);
#创建序列
CREATE SEQUENCE player_id_seq;
#将序列与表的列关联
ALTER TABLE player ALTER COLUMN player_id SET DEFAULT nextval('player_id_seq');
# 查询
select * from player;
# 插入语句
INSERT INTO player (player_name) VALUES ('John');
PostGreSql 建表及自增主键语句
最新推荐文章于 2024-08-01 08:23:29 发布