Forgot the simplest solution though, make a new table with the correct structure and insert the data into it and rename them into the right place :)
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных