I am using PostgreSQL. Can I change the order of columns?

Question

I know that the order is meaningless.

But I want to adjust the order for readability.

Can not change the order of columns in the postgresql?

I am using postico for mac. Thanks.

Answer 1

You could re-create the table with your ordering du jour. However, probably the simplest method is just to query the table with the columns you want:

select col3, col1, col4, . . .
from t;

You can wrap this in a view so you can use it anytime in the future:

create view v_t as
    select col3, col1, col4, . . .
    from t;