53.23. pg_sequences
The viewpg_sequences provides access to useful information about each sequence in the database.
Table 53.23. pg_sequences Columns
Column Type Description |
|---|
Name of schema containing sequence |
Name of sequence |
Name of sequence's owner |
Data type of the sequence |
Start value of the sequence |
Minimum value of the sequence |
Maximum value of the sequence |
Increment value of the sequence |
Whether the sequence cycles |
Cache size of the sequence |
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. |
Thelast_value column will read as null if any of the following are true:
The sequence has not been read from yet.
The current user does not have
USAGEorSELECTprivilege on the sequence.The sequence is unlogged and the server is a standby.