Re: Sequence Manipulation Functions

MG schrieb:
> 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?
>
SELECT * FROM adr_dsnr;

Otoh, for what do you need this information?

Regards
Tino