How to swap fields in a postgreSQL table?

Question

PHP

How can I swap fields in a PostgreSQL database?
I use:
1. phpPgAdmin.
2.PgAdmin.
What for? - it so happened that I forgot the id field and created it after creating the table and now it is at the very bottom ..
This is not convenient.
Is it possible to change the position of the field somehow using standard methods?

Answer 1

recreate the table on a new one or create a view with the desired position of the columns.
both methods are described here .

Answer 2

Alternatively: SELECT id, name INTO id_name_table FROM name_id_table;