2010/4/7 Olivier Baheux <[email protected]>:
> i'm trying to find where are stored sequence definition
> (increment,minvalue,maxvalue,start,cache) in system tables. Atm I
> found everything exept sequence.
It's in the sequence itself (which can be accessed like a table). The
fact that this "table" is in fact a sequence is stored in pg_class:
--------8<--------
itsme=# CREATE TABLE a (i serial);
HINWEIS: CREATE TABLE erstellt implizit eine Sequenz »a_i_seq« für
die »serial«-Spalte »a.i«
CREATE TABLE
itsme=# SELECT * FROM a_i_seq;
sequence_name | last_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
a_i_seq | 1 | 1 | 9223372036854775807 |
1 | 1 | 1 | f | f
(1 Zeile)
itsme=# SELECT relkind FROM pg_class WHERE relname = 'a_i_seq';
relkind
---------
S
(1 Zeile)
-------->8--------
Nicolas
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
