Sequences in PostgreSQL are types of objects in a database that generates sequence of integers with specific requirements. Here are few ways to list them though.
Step 1. Login to PostgreSQL first. For instance:
psql -h some_host -d some_db -U some_username
List sequences using SQL query
SELECT * FROM information_schema.sequences;
or even better:
SELECT sequence_schema, sequence_name, data_type, minimum_value, maximum_value FROM information_schema.sequences ORDER BY sequence_name;
List sequences using PSQL
Other potentially useful PostgreSQL listing queries:
On a side note, follow our official channel on Telegram.