Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment