SHOW SEQUENCES

On this page Carat arrow pointing down

The SHOW SEQUENCES statement lists all sequences in a database.

Required privileges

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

Synopsis

SHOW SEQUENCES FROM name

Parameters

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

Example

icon/buttons/copy
CREATE SEQUENCE sequence_test;
icon/buttons/copy
SHOW SEQUENCES;
  sequence_schema | sequence_name
------------------+----------------
  public          | sequence_test
(1 row)

See also


Yes No
On this page

Yes No