Use currval(<sequence name>) See:
http://www.postgresql.org/docs/7.3/static/functions-sequence.html -Nick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Pierre Couderc > Sent: Friday, August 29, 2003 11:27 AM > To: [EMAIL PROTECTED] > Subject: [ADMIN] How to read a sequence without incrementing it? > > > I would like to read the current value of a sequence, or a value > not too far of > the current value (for example, the value it was a few seconds or > minutes ago). > Is it possible (without any nexrval that should increment it)? > > Thank you all > > Pierre Couderc > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster