Pasted

Switch schemas
===
DROP TABLE IF EXISTS datamart.some_table;
ALTER TABLE staging.some_table SET SCHEMA datamart;
 
Rename staged table
===
DROP TABLE IF EXISTS encounters;
ALTER TABLE stage_encounters RENAME TO encounters;
 
Create snapshot table
===
DROP TABLE encounters_snap CASCADE;
CREATE TABLE encounters_snap AS
 SELECT * FROM encounters;
 
Snapshot and switch schemas (no indexes)
===
DROP TABLE IF EXISTS datamart.some_table;
ALTER TABLE datamart.some_table RENAME TO datamart.some_table_snap;
ALTER TABLE staging.some_table SET SCHEMA datamart;