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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster