Re: system table storing sequence attributes

From: Marcin Stępnicki <mstepnicki(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: system table storing sequence attributes
Date: 2007-05-22 07:43:23
Message-ID: pan.2007.05.22.07.43.23.678145@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia Tue, 22 May 2007 10:03:28 +0300, Sabin Coanda napisał(a):

> Hi there,
>
> I'd like to read the global sequence attribute "currval", but not using
> currval function, because it is session dependent and requires a nextval
> function to be used before.
>
> Do you know where is stored this value in the system tables ?

select last_value from sequence_name

--
| And Do What You Will be the challenge | http://apcoln.linuxpl.org
| So be it in love that harms none | http://biznes.linux.pl
| For this is the only commandment. | http://www.juanperon.info
`---* JID: Aragorn_Vime(at)jabber(dot)org *---' http://www.naszedzieci.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sabin Coanda 2007-05-22 12:23:44 Re: system table storing sequence attributes
Previous Message Sabin Coanda 2007-05-22 07:03:28 system table storing sequence attributes