Postgres reorder columns

    PostgreSQL currently defines column order based on the attnum column of the pg_attribute table. The only way to change column order is either by recreating the table, or by adding columns and rotating data until you reach the desired layout.
    
    ----
    
    CREATE VIEW original_tab_vw AS
    SELECT a.col1, a.col3, a.col4, a.col2
    FROM original_tab a
    WHERE a.col1 IS NOT NULL --or whatever

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
Search starting with mysql
SQL
0 vote176 views1 answer
Is numeric in sql
SQL
1 vote185 views1 answer
Mysql breakline on string
SQL
1 vote217 views1 answer
Backup mysql schema only
SQL
5 votes232 views2 answers
How to ascending order in sql
SQL
0 vote190 views1 answer
Postgres read table structure
SQL
7 votes206 views2 answers
Sql remove duplicates based on column
SQL
1 vote182 views1 answer
Sql server datetime vs datetime2
SQL
0 vote176 views1 answer
Get employees if not contains in sql
SQL
-3 votes183 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL