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

1 vote142 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote137 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote158 views1 answer
Postgres clear table
SQL
1 vote135 views1 answer
Oracle avg
SQL
1 vote135 views1 answer
Update from select join
SQL
1 vote148 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote96 views1 answer
How to run sql script
SQL
-1 vote196 views5 answers
Left join sql
SQL
1 vote135 views2 answers
Mysql: command not found
SQL
2 votes144 views1 answer
Metasploit start postgresql
SQL