------create new temp table-----

 create table order_temp3 as
select row_number()over()as rn,* 
from "BinarPlatinum".orders_table;

----drop existing table
drop table "BinarPlatinum".orders_table; 

----rename new temp table into orders_table
ALTER TABLE public.order_temp3 RENAME TO orders_table;