I am new to Postgres and I am trying to build this SQL statement in my SQL script: ALTER TABLE listings_cdc ALTER COLUMN table_id SET DEFAULT nextval('tab_id_seq');
I am trying to build the above-stated command as a dynamic SQL statement: EXECUTE 'ALTER TABLE listings_cdc ALTER COLUMN table_id SET DEFAULT nextval('||quote_ident(tab_id_seq)||')';
I've received an error when running the script this above-stated command: ERROR: column "tab_id_seq" does not exist LINE 1: ...OLUMN table_id SET DEFAULT nextval('||quote_ident(tab_id_seq...
Need help on how to write the above-stated command as a dynamic SQL statement.
In addition, do you know of a tutorial or a book that I can purchase that teaches how to build dynamic SQL statements