Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Sequence objects have no global currval operator? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Sequence objects have no global currval operator?
Date
Msg-id 11494.900367371@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Sequence objects have no global currval operator?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <maillist@candle.pha.pa.us> writes:
> How about SELECT * FROM sequence_table_name?

Ah, of course.  The man page for CREATE SEQUENCE only mentions getting
the sequence parameters that way, but you can get the last_value as
well, which is exactly what I need.

Maybe I'll submit a documentation change to make this clearer for the
next guy.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Sequence objects have no global currval operator?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] more nodeError problems and general view failures!