On Mon, 20 Oct 2003, CSN wrote:
> How do you get the last value of a sequence without
> having called nextval? phppgadmin displays last value
> for sequences (I haven't found out how yet rooting
> through the code).
First, the mandatory, why would you want to do that?
Second: select last_value from table_id_seq;
It's not transaction safe, so don't expect it to work right on busy
multi-user systems.