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

8 votes349 views1 answer
Oracle add datafile to tablespace
SQL
1 vote334 views1 answer
Oracle select first result
SQL
0 vote320 views1 answer
Oracle procedure teamplate
SQL
0 vote338 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
10 votes362 views4 answers
Mysql if else
SQL
1 vote321 views1 answer
Get last week data in mysql
SQL
11 votes345 views4 answers
MYSQL LOGIN
SQL
0 vote328 views2 answers
Collation in sql
SQL
0 vote307 views1 answer
Remove from table where
SQL
1 vote338 views1 answer
Sql select max value from multiple rows
SQL