select last_value from 'seq';

>From: Pierre Couderc
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] How to read a sequence without incrementing it?
>Date: Fri, 29 Aug 2003 18:27:09 +0200
>
>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


Get MSN 8 and enjoy automatic e-mail virus protection.