How do I set a serial column with the next value when the serial object has a name that is built dynamically?
EXECUTE 'CREATE SEQUENCE '|| t_name || 'id_seq' || ' OWNED BY '|| t_name || '_cdc'||'.table_id';
EXECUTE 'ALTER TABLE ' || quote_ident(t_name || '_cdc') || ' ALTER COLUMN table_id SET DEFAULT nextval(''tab_id_seq'');';
EXECUTE 'CREATE SEQUENCE '|| t_name || 'id_seq' || ' OWNED BY '|| t_name || '_cdc'||'.table_id';
EXECUTE 'ALTER TABLE ' || quote_ident(t_name || '_cdc') || ' ALTER COLUMN table_id SET DEFAULT nextval(''tab_id_seq'');';