From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "Forums (at) Existanze" <forums(at)existanze(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Getting information about sequences |
Date: | 2006-05-15 14:13:51 |
Message-ID: | 20060515141351.GB21506@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | dfx | 2006-05-15 14:19:59 | parameter passing from java program |
Previous Message | Kenneth Downs | 2006-05-15 14:13:45 | Re: GUI Interface |