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 vote137 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote105 views1 answer
Mysql date minus 1 day
SQL
0 vote109 views1 answer
Get foreign table names mysql
SQL
0 vote104 views1 answer
Oracle last connection
SQL
0 vote113 views1 answer
How to find date from date table in sql
SQL
17 votes108 views6 answers
Sql select distinct
SQL
2 votes111 views1 answer
Oracle sql merge
SQL
1 vote110 views1 answer
Postgresql if 0 then 1
SQL
0 vote126 views1 answer
Mysql export data with a where clause
SQL
0 vote104 views1 answer
Mysql timediff
SQL