Re: Sequences

Thanks, I have used

SELECT sequence_name FROM information_schema.sequences WHERE 
sequence_catalog=? AND sequence_schema=?

and then I can use

select * from <sequence-name>

It seems to work :-)
Andre

Chris Browne wrote:
> 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.