After import from MSSQL to Postgres update Import ClickSTAGING.dbo ClickDW.dbo ClickDW.internal Update auto number keys for tables CickSTAGING.dbo.datacontract Set indentity on datacontractid 4851 CickSTAGING.dbo.dataimport Set indentity on dataimportid 4851 CickSTAGING.dbo.dataimportlog Set indentity on dataimportlogid ClickDW.internal.dataimportlog Set identity on dataimportlogid 4496896 ClickDW.internal.dataimportaudit Set identity on dataimportauditid 9161893 ClickDW.internal.dataexportaudit Set identity on ?? Vacuum -- vacuum full; vacuum CickSTAGING.dbo.learner; vacuum ClickDW.dbo.SourceLearner; vacuum ClickDW.internal.DataImport; On update of SP's using SCT reload views