ALTER TABLE boxes ADD COLUMN user_uuid uuid; u UPDATE boxes T SET user_uuid = (SELECT uuid FROM users WHERE id = T.user_id); u ALTER TABLE boxes ALTER COLUMN user_id TYPE uuid USING user_uuid; u ALTER TABLE boxes DROP COLUMN user_uuid; u ALTER TABLE boxes ADD FOREIGN KEY (user_id) REFERENCES users(id);