PG_SEQUENCES

PG_SEQUENCES displays the sequence attributes on which the current user has permissions. This view is supported only by clusters of version 9.1.0 or later.

**Table 1** PG_SEQUENCES columns
Column	Type	Description
schemaname	Name	Name of the namespace.
sequencename	Name	Name of the sequence
sequenceowner	Name	Owner of the sequence
start_value	Bigint	Start value of the sequence.
min_value	Bigint	Minimum value generated by the sequence.
max_value	Bigint	Maximum value generated by the sequence.
increment_by	Bigint	Amount by which the generated value increases each time in a sequence.
cycle	Boolean	If set to true, the sequence value restarts from the minimum value after reaching the maximum value. If set to false, the sequence value stops generating after reaching the maximum value.
cache_size	Bigint	Size of the sequence cache value.
last_value	Bigint	Most recently generated value of the sequence.