we are in process of migrating to postgres and need to reset the sequence number with highest value of table key . I want to make it procedural to do that as mentioned below,But it's throwing an error .
DO $$ DECLARE SEQ BIGINT; BEGIN SEQ:=(SELECT MAX(ID) FROM TABLE_1); ALTER SEQUENCE TABLE_1_SEQ RESTART WITH SEQ; END$$; Error : syntax error at or near "SEQ" -- Thanks & Regards, Brahmeswara Rao J.
