Re: Sequences - Mailing list pgsql-sql

From Jasmin Dizdarevic
Subject Re: Sequences
Date
Msg-id a0eee4d40907040535tf4cf625y891a923832f86035@mail.gmail.com
Whole thread Raw
In response to Re: Sequences  (Chris Browne <cbbrowne@acm.org>)
Responses Re: Sequences
List pgsql-sql
Nice Information. Does somebody know how to get the complete create-statement of an existing table/view?

2009/7/3 Chris Browne <cbbrowne@acm.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?

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



--
Mit freundlichen Grüßen

Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT

jasmin.dizdarevic@gmail.com
+43 664 411 79 29

pgsql-sql by date:

Previous
From: Chris Browne
Date:
Subject: Re: Sequences
Next
From: Scott Marlowe
Date:
Subject: Re: Sequences