seq nextval

CREATE SEQUENCE seq_name OWNED BY table_name.seq_id;
ALTER TABLE table_name ALTER COLUMN seq_id SET DEFAULT nextval('seq_name');
UPDATE table_name SET seq_id = nextval('seq_name');