- We are migrating data from a postgres DB to new EDB database .
- We have migrated the sequence and all table data also .
- Both DB is installed on a remote unix server and on diffrent machines.
- There are 300+ sequences .
Issue : As we have inserted all table data by running a bunch of insert command which was exported from Dbeaver . And those insert command does not contains nextval() function . So all sequences in DB is still initialized with initial value . How to update the nextval of all sequence of all schema with the last value in new DB(EDB) as it was in old DB(postgres) ?