Postgres插入自增主键

1、创建表方式
CREATE TABLE customers
(
id SERIAL primary key ,
name character varying,
description character varying
)
2、创建序列方式
CREATE SEQUENCE dict_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

alter table dict alter column id set default nextval('dict_seq');  

3、查询已有的序列

–查看数据库中有哪些序列
–r =普通表， i =索引，S =序列，v =视图，m =物化视图， c =复合类型，t = TOAST表，f =外部表
select * from pg_class where relkind=‘S’