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

11 votes330 views2 answers
Import mysql dump command line windows
SQL
0 vote216 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote235 views1 answer
Sql describe
SQL
0 vote183 views1 answer
Drop constraint in ms sql
SQL
0 vote186 views1 answer
Mysql cli output to a file
SQL
1 vote200 views3 answers
Update from select sqlite
SQL
0 vote188 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote222 views1 answer
Oracle list dblink
SQL
6 votes200 views4 answers
Mysql group by date
SQL
10 votes188 views5 answers
Create table mysql query
SQL