-- 使用SERIAL自增主键
create table open.t_ttt(
id SERIAL primary key,
name varchar(20)
);
-- 插入
insert into open.t_ttt (name) values ('daiyuanpei');
-- 会自动创建唯一索引 可通过此语句查看
select * from pg_indexes where tablename='t_ttt';
-- 会自动生成对应的表 open.t_ttt_id_seq
\d open.t_ttt_id_seq;