PostgreSQL

PostgreSQL Elephant Logo

51.84. pg_sequences

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

Table 51.85. 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.83. pg_seclabels

Home

51.85. pg_settings

Copyright © 1996-2023 The PostgreSQL Global Development Group