Re: lastval(seq) ?

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: lastval(seq) ?
Date: 2003-10-21 12:10:12
Message-ID: 20031021081012.2f4521f4.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 20 Oct 2003 21:52:17 -0700 (PDT)
CSN <cool_screen_name90001(at)yahoo(dot)com> 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).
>
> CSN
>

select curval('my_sequence')

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cláudia Morgado 2003-10-21 12:38:34 DBDesigner for Linux
Previous Message Diogo Biazus 2003-10-21 10:54:39 About TSearch2 Performance