November 14, 2024: PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
51.85. pg_sequences
Prev  Up Chapter 51. System Catalogs Home  Next

51.85. pg_sequences

The view pg_sequences provides access to useful information about each sequence in the database.

Table 51.86. pg_sequences Columns

Name Type References Description
schemaname name pg_namespace.nspname Name of schema containing sequence
sequencename name pg_class.relname Name of sequence
sequenceowner name pg_authid.rolname Name of sequence's owner
data_type regtype pg_type.oid Data type of the sequence
start_value bigint   Start value of the sequence
min_value bigint   Minimum value of the sequence
max_value bigint   Maximum value of the sequence
increment_by bigint   Increment value of the sequence
cycle boolean   Whether the sequence cycles
cache_size bigint   Cache size of the sequence
last_value bigint   The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence. Null if the sequence has not been read from yet. Also, if the current user does not have USAGE or SELECT privilege on the sequence, the value is null.

Prev  Up  Next
51.84. pg_seclabels  Home  51.86. pg_settings