adding row_number row_id to table

PHOTO EMBED

Tue Mar 08 2022 05:12:02 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

 ------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;
content_copyCOPY