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.
signature.asc
Description: Digital signature
