Sequences

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Sequences
Date: 2018-12-04 19:03:11
Message-ID: 87E05184-8087-4225-BBCC-F60B74F18023@illinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 10.x

What query will give the name of all sequences in a database and the current or next value for each sequence?

This will give me everything except for the next value in the sequence.

SELECT * FROM information_schema.sequences;

Thanks,

Lance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Balashov 2018-12-04 19:17:51 Re: Sequences
Previous Message Stephen Frost 2018-12-04 15:38:14 Re: pg_basebackup fails: could not receive data from WAL stream: server closed the connection unexpectedly