On Jan 10 03:56, MG wrote:
> 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
test=# \d roomsold_main_id_seq
Sequence "public.room
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 cu
Select last_value from your_sequence_name;
John
MG wrote:
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 t
