"Campbell, Lance" <lance(at)illinois(dot)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';
regards, tom lane