-- renaming sequences

CREATE SEQUENCE foo_seq;

ALTER TABLE foo_seq RENAME TO foo_seq_new;

SELECT sequence_name, last_value, start_value, increment_by, max_value,

min_value, cache_value, is_cycled, is_called FROM foo_seq_new;

sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | is_cycled | is_called

---------------+------------+-------------+--------------+---------------------+-----------+-------------+-----------+-----------

foo_seq | 1 | 1 | 1 | 9223372036854775807 | 1 | 1 | f | f

SELECT * FROM foo_seq_new;

sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called

---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------

foo_seq | 1 | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f

(1 row)

SELECT nextval('foo_seq_new');

2

(1 row)

SELECT sequence_name, last_value, start_value, increment_by, max_value,

min_value, cache_value, is_cycled, is_called FROM foo_seq_new;

sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | is_cycled | is_called

---------------+------------+-------------+--------------+---------------------+-----------+-------------+-----------+-----------

foo_seq | 2 | 1 | 1 | 9223372036854775807 | 1 | 1 | f | t

SELECT * FROM foo_seq_new;

sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called

---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------

foo_seq | 2 | 1 | 1 | 9223372036854775807 | 1 | 1 | 32 | f | t

(1 row)

DROP SEQUENCE foo_seq_new;

CREATESEQUENCEfoo_seq;

ALTERTABLE foo_seq RENAME TO foo_seq_new;

SELECT sequence_name, last_value, start_value, increment_by, max_value,

min_value, cache_value, is_cycled, is_calledFROM foo_seq_new;

SELECT*FROM foo_seq_new;

SELECT nextval('foo_seq_new');

SELECT nextval('foo_seq_new');

SELECT sequence_name, last_value, start_value, increment_by, max_value,

min_value, cache_value, is_cycled, is_calledFROM foo_seq_new;

SELECT*FROM foo_seq_new;

DROPSEQUENCE foo_seq_new;