"Campbell, Lance" <lance@illinois.edu> writes: > Is there a way to get a list of all sequences, the schema it is used in, and the current sequence number in use?
Try something like
select relname, relnamespace::regnamespace, pg_sequence_last_value(oid) from pg_class where relkind = 'S';