SHOW SEQUENCES

On this page

The SHOW SEQUENCES statement lists all sequences in a database.

Required privileges

No privileges are required to list the sequences in a database.

Parameter	Description
`name`	The name of the database for which to list sequences. When omitted, the sequences in the current database are listed.

> CREATE SEQUENCE sequence_test;

> SHOW SEQUENCES;

  sequence_schema | sequence_name
------------------+----------------
  public          | sequence_test
(1 row)