PostgreSQL sequence name


Get a list of sequence_name in PostgreSQL with information_schema:

SELECT sequence_name
FROM information_schema.sequences;

Alternatively, check pg_class relname:

SELECT relname
FROM pg_class
WHERE relkind = 'S';


Please support this site and join our Discord!