psql get sequences

Solutions on MaxInterview for psql get sequences by the best coders in the world

showing results for - "psql get sequences"
Finn
23 Jan 2021
1# Get all sequences
2SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
3
4# Get last value of a sequence
5SELECT last_value FROM test_id_seq;