Re: Getting information about sequences - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Getting information about sequences
Date
Msg-id 20060515141351.GB21506@svana.org
Whole thread Raw
In response to Getting information about sequences  ("Forums @ Existanze" <forums@existanze.com>)
Responses Re: Getting information about sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, May 15, 2006 at 03:55:49PM +0300, Forums @ Existanze wrote:
> Hello all,
>
> I would like to ask if anyone can explain or point me to some sort of query
> that would get the sequences for a database along with the current value
> they contain.
>
> I have been able to get the sequence names, but I can get their values all
> in one query. From the documentation I can't use currval() because it needs
> setval() to precede it in the same session.

Select sequence.last_value;

It's not guarenteed to give a value that unique across users, that's
what currval/nextval are for. For if you just want an idea of where
it's up to, this will do.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postmaster cannot start
Next
From: Kenneth Downs
Date:
Subject: Re: GUI Interface