CREATE SCHEMA sequences_schema;
SET search_path TO sequences_schema;
CREATE SEQUENCE seq_0;
ALTER SEQUENCE seq_0 AS smallint;
CREATE SEQUENCE seq_1;
ALTER SEQUENCE seq_1 AS bigint;
CREATE TABLE seq_test_0 (x bigint, y bigint);
SELECT create_distributed_table('seq_test_0','x');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

INSERT INTO seq_test_0 SELECT 1, s FROM generate_series(1, 50) s;
SELECT * FROM seq_test_0 ORDER BY 1, 2 LIMIT 5;
 x | y
---------------------------------------------------------------------
 1 | 1
 1 | 2
 1 | 3
 1 | 4
 1 | 5
(5 rows)

ALTER TABLE seq_test_0 ADD COLUMN z bigint;
ALTER TABLE seq_test_0 ALTER COLUMN z SET DEFAULT nextval('seq_0');
ALTER TABLE seq_test_0 ALTER COLUMN y SET DEFAULT nextval('seq_1');
ALTER SEQUENCE seq_0 RENAME TO renamed_seq;