Move Sequence to Different Schema

[sarah]

Howdy,

How can I move a sequence from one schema to another without dropping and re-creating it?

Thanks!

[JimKnicely]

Use the ALTER SEQUENCE SET SCHEMA command.

Example:

Code: Select all

dbadmin=> create sequence jim_seq;
CREATE SEQUENCE
dbadmin=> \ds jim_seq;
                                           List of Sequences
 Schema | Sequence | CurrentValue | IncrementBy | Minimum |       Maximum       | AllowCycle | Comment 
--------+----------+--------------+-------------+---------+---------------------+------------+---------
 public | jim_seq  |            0 |           1 |       1 | 9223372036854775807 | f          | 
(1 row)

dbadmin=> create schema jim;
CREATE SCHEMA

dbadmin=> alter sequence jim_seq set schema jim;
ALTER SEQUENCE

dbadmin=> \ds jim_seq;
                                           List of Sequences
 Schema | Sequence | CurrentValue | IncrementBy | Minimum |       Maximum       | AllowCycle | Comment 
--------+----------+--------------+-------------+---------+---------------------+------------+---------
 jim    | jim_seq  |            0 |           1 |       1 | 9223372036854775807 | f          | 
(1 row)