Postgres Pro
Downloads
Home   >   mailing lists

Sequences - Mailing list pgsql-admin

From Campbell, Lance
Subject Sequences
Date
Msg-id 87E05184-8087-4225-BBCC-F60B74F18023@illinois.edu
Whole thread Raw
Responses Re: Sequences  (Alex Balashov <abalashov@evaristesys.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_basebackup fails: could not receive data from WAL stream:server closed the connection unexpectedly
Next
From: Alex Balashov
Date:
Subject: Re: Sequences