Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group