Re: checking currval

From: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: checking currval
Date: 2003-06-18 14:00:39
Message-ID: 3EF07087.8080409@zhengmai.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

select last_value from your_sequence;

Jodi Kanter wrote:

> I cannot view the currval because it is not set in the session yet. Is
> there a way to set it without having to increment the value?
> Thanks
> Jodi

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-06-18 14:10:47 Re: Bad link on techdocs
Previous Message Jodi Kanter 2003-06-18 13:55:51 checking currval