deeejay

psql - Table Juggling

Oct 23rd, 2015
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Switch schemas
  2. ===
  3. DROP TABLE IF EXISTS datamart.some_table;
  4. ALTER TABLE staging.some_table SET SCHEMA datamart;
  5.  
  6. Rename staged table
  7. ===
  8. DROP TABLE IF EXISTS encounters;
  9. ALTER TABLE stage_encounters RENAME TO encounters;
  10.  
  11. Create snapshot table
  12. ===
  13. DROP TABLE encounters_snap CASCADE;
  14. CREATE TABLE encounters_snap AS
  15.  SELECT * FROM encounters;
  16.  
  17. Snapshot and switch schemas (no indexes)
  18. ===
  19. DROP TABLE IF EXISTS datamart.some_table;
  20. ALTER TABLE datamart.some_table RENAME TO datamart.some_table_snap;
  21. ALTER TABLE staging.some_table SET SCHEMA datamart;
Advertisement
Add Comment
Please, Sign In to add comment