ALTER TABLE followers ADD COLUMN acct_migr character varying(64) NOT NULL; UPDATE followers SET acct_migr = acct; ALTER TABLE followers DROP COLUMN acct; ALTER TABLE followers ADD COLUMN acct character varying(64) NOT NULL; UPDATE followers SET acct = acct_migr; ALTER TABLE followers DROP COLUMN acct_migr;