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';