From: Chris Browne <cbbrowne@acm.org>
Subject: Re: Sequences
Date: Fri, 03 Jul 2009 17:35:41 -0400
Organization: cbbrowne Computing Inc
Lines: 19
Message-ID: <871vox4fgy.fsf@dba2.int.libertyrms.com>
References: <h2kuq1$3eh$01$1@news.t-online.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.22 (linux)
Cancel-Lock: sha1:d8GwQ+eM5xtHg7zINFy7lfCaRzw=
To: pgsql-sql@postgresql.org

Andre Rothe <arothe@phosco.info> writes:
> Where are stored the sequence information? How I can query the
> properties of a sequence like increment, max/min value, cache?
> I'm looking for a table like user_sequences in Oracle, where I
> can query all of my sequences.

cbbrowne=# create sequence foo;
CREATE SEQUENCE
cbbrowne=# select * from foo;
 sequence_name | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 foo           |          1 |            1 | 9223372036854775807 |         1 |           1 |       1 | f         | f
(1 row)

Each sequence is effectively a relation.
-- 
output = ("cbbrowne" "@" "cbbrowne.com")
http://www3.sympatico.ca/cbbrowne/wp.html
Where do you want to Tell Microsoft To Go Today?