postgres find all sequences with their tables code example
Example: psql get sequences
# Get all sequences
SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
# Get last value of a sequence
SELECT last_value FROM test_id_seq;
# Get all sequences
SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
# Get last value of a sequence
SELECT last_value FROM test_id_seq;