Sequence Manipulation Functions

From: "MG" <pgsql-general(at)carladata(dot)de>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Sequence Manipulation Functions
Date: 2006-01-10 14:56:04
Message-ID: 001f01c615f5$fac4a540$340aa8c0@geisslinger
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I use PostgreSQL 8.0.3.

I want to get the information of the last value of a sequence.

The function 'currval' only gives the value back, if before a nextval is executed.
Return the value most recently obtained by nextval for this sequence in the current session. (An error is reported if nextval has never been called for this sequence in this session.) Notice that because this is returning a session-local value, it gives a predictable answer whether or not other sessions have executed nextval since the current session did.

But that is not very helpful.

I noticed that the phpPgAdmin has that information

Name Last value Increment by Max value Min value Cache value Log count Is cycled? Is called?
adr_dsnr 108 1 9223372036854775807 1 1 25 No Yes

So how can I get that information?

Thanks

Michaela

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-01-10 16:00:52 Re: regarding triggers
Previous Message Jaime Casanova 2006-01-10 14:51:25 Re: regarding triggers