PostgreSQL创建序列号
在创建数据表table时,我们经常需要同时创建表序列号,以此来保证新增数据的唯一性。在此简单记录下序列号的创建方式:
Sequences are frequently used in many databases because many applications require each row in a table to contain a unique value and sequences provides an easy way to generate them.
create sequence "{{表序列号名称}}"
increment 1
minvalue 1
maxvalue 9223372036854775807
start 1
cache 1
设置序列号
- 先查询表最大id: maxValue
- 设置序列:
alter sequence {{序列名}} restart with {{maxValue}};
查询序列
select currentval('{{序列名}}');