Обсуждение: Setting a serial column with serial object that has a name that isbuilt dynamically

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'*');';