Change order of columns in PostgreSQL

column_reorder.sql

CREATE TABLE tone_data_temp AS
SELECT file_name, last_update, category, word_count, litigious,
	positive, uncertainty, negative, modal_strong, modal_weak 
FROM bgt.tone_data;

DROP TABLE bgt.tone_data;

ALTER TABLE tone_data_temp RENAME TO tone_data;
ALTER TABLE tone_data SET SCHEMA bgt;