Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sequences

0 views
Skip to first unread message

Andre Rothe

unread,
Jul 3, 2009, 8:43:13 AM7/3/09
to
Hi!

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.

Thanks
Andre

Thomas Kellerer

unread,
Jul 3, 2009, 9:01:28 AM7/3/09
to
Andre Rothe, 03.07.2009 14:43:

http://www.postgresql.org/docs/current/static/infoschema-sequences.html

But

SELECT *
FROM sequence_name

gives more detailed information

Thomas

Andre Rothe

unread,
Jul 3, 2009, 9:29:46 AM7/3/09
to
Hi,

So I can look into information_schema.sequences for all the names
and then I can query every sequence name for details. Nice.

Thanks a lot
Andre

0 new messages