Use currval(<sequence name>)
See:
http://www.postgresql.org/docs/7.3/static/functions-sequence.html
-Nick
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Pierre Couderc
> Sent: Friday, August 29, 2003 11:27 AM
> To: pgsql-admin@postgresql.org
> 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
>