SHOW SEQUENCES

The SHOW SEQUENCES lists all sequences in a database.

Required privileges

No are required to list the sequences in a database.

Synopsis

Parameters

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

Example

> CREATE SEQUENCE sequence_test;

> SHOW SEQUENCES;

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

See also