I know that I can get a list of all sequences with
SELECT
c.relname AS sequencename
FROM pg_class c WHERE (c.relkind = 'S');
which produces, for example,
country_country_pk_seq
province_province_pk_seq
city_city_pk_seq
postal_code_postal_code_pk_seq
And I know I can get the last value from a particular sequence with
SELECT
sequence_name,
last_value
FROM city_city_pk_seq
which produces, for example
city_city_pk_seq 14702
But how can I get a list of sequence names and the respective last value
for ALL sequences?
~Berend Tober