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

3 votes108 views2 answers
Order by postgresql
SQL
3 votes140 views2 answers
@sqlresultsetmapping
SQL
0 vote147 views1 answer
Mysql faster delete
SQL
-2 votes114 views3 answers
Sqlite reset autoincrement
SQL
9 votes100 views4 answers
Add primary key to existing table sql
SQL
0 vote103 views1 answer
Get number of rows in every table mysql
SQL
0 vote115 views1 answer
Mysql remove bad character from all fields
SQL
1 vote101 views1 answer
Local sql server
SQL
0 vote137 views1 answer
Oracle plsql sleep
SQL
1 vote102 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL