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 vote275 views2 answers
2nd max salary query in sql
SQL
0 vote303 views1 answer
Closure in sql
SQL
0 vote286 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote300 views1 answer
Postgresql create query
SQL
0 vote285 views1 answer
How to export only procedures mysql
SQL
5 votes283 views1 answer
Sql use database
SQL
1 vote280 views3 answers
Grant syntax in sql
SQL
0 vote301 views1 answer
Where date major today mysql
SQL
3 votes282 views1 answer
Select table column in sql
SQL
5 votes279 views2 answers
Sql server check port number
SQL