Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.
Richard Huxton <dev@archonet.com> wrote:
sid tow wrote: > HI > > I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do > > psql=# select * from foo_seq; > sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called > ---------------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+----------- > foo_seq | 11 | 1 | 9223372036854775807 | 1 | 1 | 0 | f | t > (1 row) > > I need to know where do i find documentation to know what the columns specify and I have already checked the man pages of create_sequence where I did not find much. > Can somebody give me ref to a link where I get such information.
From the manuals: CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
For the ones not mentioned in the manual: last_value - is the last value given out by the sequence is_called - says whether nextval() has been called in this session (and so whether it is safe to call currval()) log_cnt - don't know, googling suggests it's to do with WAL logging.