Problem with the sequence

From: sid tow <siddy_tow(at)yahoo(dot)com>
To: psql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Problem with the sequence
Date: 2005-02-03 06:25:37
Message-ID: 20050203062537.26931.qmail@web42105.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.


---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-02-03 06:59:03 psql question on echo output
Previous Message Andrew Hall 2005-02-03 05:56:25 Lost rows / corrupt data?