Setting a serial column with serial object that has a name that is built dynamically

Started by Robert Lakesover 8 years ago1 messagesgeneral
Jump to latest
#1Robert Lakes
robertl@propaas.com

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