redshift_table_change

START TRANSACTION ;

ALTER TABLE schema_name.table_name RENAME TO table_name_old;

CREATE TABLE schema_name.table_name_new
-- Creation statement
;

INSERT INTO schema_name.table_name_new (
  SELECT
    *
  FROM schema_name.table_name_old
);

ALTER TABLE schema_name.table_name_new RENAME TO table_name;

DROP TABLE schema_name.table_name_old;

ROLLBACK ;
COMMIT ;