From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Sequences |
Date: | 2009-07-03 21:35:41 |
Message-ID: | 871vox4fgy.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Andre Rothe <arothe(at)phosco(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Jasmin Dizdarevic | 2009-07-04 12:35:20 | Re: Sequences |
Previous Message | Andre Rothe | 2009-07-03 12:50:08 | Sequences |