Function to return all your postgres sequences and their last value

gistfile1.sql

create or replace function sequence_positions(OUT sequence_name regclass, OUT last_value bigint) returns setof record as $$
declare
  sequence regclass;
begin
  FOR sequence IN SELECT format('%s.%s', n.nspname, c.relname) AS sequence FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid) WHERE (c.relkind = 'S')
  LOOP
    return query execute format('select ''%s''::regclass, last_value from %s', sequence, sequence);
  END LOOP;
end
$$ language plpgsql;