Renaming a Postgres sequence used by multiple tables.

safe_rename.log

testy=# CREATE SEQUENCE common_fruit_id_seq;
CREATE SEQUENCE
testy=# 
testy=# CREATE TABLE apples (
testy(#     id      INT4 DEFAULT nextval('common_fruit_id_seq') NOT NULL,
testy(#     price   NUMERIC
testy(# );
CREATE TABLE
testy=# 
testy=# CREATE TABLE oranges (
testy(#     id      INT4 DEFAULT nextval('common_fruit_id_seq') NOT NULL,
testy(#     weight  NUMERIC
testy(# );
CREATE TABLE
testy=# \d oranges
                            Table "public.oranges"
 Column |  Type   |                         Modifiers                         
--------+---------+-----------------------------------------------------------
 id     | integer | not null default nextval('common_fruit_id_seq'::regclass)
 weight | numeric | 

testy=# ALTER TABLE "common_fruit_id_seq" RENAME TO "all_the_fruit_id_seq";
ALTER TABLE
testy=# \d oranges
                            Table "public.oranges"
 Column |  Type   |                         Modifiers                          
--------+---------+------------------------------------------------------------
 id     | integer | not null default nextval('all_the_fruit_id_seq'::regclass)
 weight | numeric | 

testy=# \d apples
                             Table "public.apples"
 Column |  Type   |                         Modifiers                          
--------+---------+------------------------------------------------------------
 id     | integer | not null default nextval('all_the_fruit_id_seq'::regclass)
 price  | numeric |