# PostgresSQL 获得下一个 Sequence 的值

**URL:** <https://www.isharkfly.com/t/postgressql-sequence/16061>\
**Category:** 数据库\
**Tags:** postgresql\
**Created:** [July 30, 2024, 7:09pm UTC](https://www.isharkfly.com/t/postgressql-sequence/16061 "2024-07-30T19:09:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [July 30, 2024, 7:09pm UTC](https://www.isharkfly.com/t/postgressql-sequence/16061/1 "2024-07-30T19:09:53Z")

</div>

要获得下一个 Sequence 的值，我们需要执行 SQL `select nextval('topics_id_seq' )`

 ![2024-07-30_15-09-16](https://cdn.isharkfly.com/com-isharkfly-www/discourse-uploads/original/2X/0/04719acc5e45fe3833c86e3ccb14103634692468.png)

每执行一次，值就会增加一个。