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

4 votes267 views1 answer
Mysql set max connections
SQL
0 vote294 views1 answer
Repeatable read trong sql server
SQL
15 votes276 views4 answers
How to get all tables in sql
SQL
4 votes280 views5 answers
Primary key
SQL
0 vote315 views1 answer
How to find date from date table in sql
SQL
0 vote303 views1 answer
Sql max of two values
SQL
1 vote288 views1 answer
Mysql check string don't have number
SQL
0 vote294 views1 answer
Update top 100 order by sql server
SQL
2 votes282 views4 answers
Duplicate record mysql
SQL
0 vote279 views1 answer
Sql server roles and users
SQL