SHOW SEQUENCES

The SHOW SEQUENCES statement lists all sequences in a database.

Required privileges

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

Synopsis

SHOWSEQUENCESFROMname

Parameters

ParameterDescription
nameThe name of the database for which to list sequences. When omitted, the sequences in the current database are listed.

Example

  1. > CREATE SEQUENCE sequence_test;
  1. > SHOW SEQUENCES;

  1.  sequence_name

sequence_test
(1 row)

See also

Was this page helpful?
YesNo