GP数据库篇：随便笔记

前言

　　随便笔记，随便记录，方便查找

　　给已存在的表字段添加自增

给与存在的表字段添加自增

/*先创建序列*/
CREATE SEQUENCE test_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

start with 序列开始值

increment by 递增值

ALTER TABLE dbname ALTER COLUMN id SET default nextval('test_id_seq');

断开指定数据库的所有连接 

select pg_terminate_backend(pid) from (select pid from pg_stat_activity where datname = 'dbname' ) a;