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.