Sequences

#1

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

#2

Andre Rothe, 03.07.2009 14:43:

Quote:

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.

http://www.postgresql.org/docs/curre...sequences.html

But

SELECT *
FROM sequence_name

gives more detailed information

Thomas

#3

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

Thomas Kellerer wrote:

Quote:

Andre Rothe, 03.07.2009 14:43:
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.

http://www.postgresql.org/docs/curre...sequences.html

But
SELECT * FROM sequence_name

gives more detailed information

Thomas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sequences

comp.databases.postgresql comp.databases.postgresql

Sequences - 07-03-2009 , 08:43 AM

Re: Sequences - 07-03-2009 , 09:01 AM

Re: Sequences - 07-03-2009 , 09:29 AM