Postgresql学习记录

pg sequence 相关操作

查询序列的相关信息

select * from pg sequence where segrelid = 'seq_name'::regclass;

修改序列的类型为 bigint

alter sequence "seq_name" as bigint MAXVALUE 9223372036854775807;

查询 表的序列名

select pg_get_serial_sequence('table_name','column_name');