Reset Sequence number

[Brahmam Eswar <brahmam1234@xxxxxxxxx>]

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.