How to list sequences in PostgreSQL

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.

Prerequisites

• PostgreSQL

Solution

Step 1. Login to PostgreSQL first. For instance:

psql -h some_host -d some_db -U some_username

List sequences using SQL query

Step 2.

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

Step 2.

\ds

Conclusion

Other potentially useful PostgreSQL listing queries:

• List Indexes in PostgreSQL
• List Stored Procedures in PostgreSQL
• List Triggers in PostgreSQL

On a side note, follow our official channel on Telegram.