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 votes202 views4 answers
Reset identity column values in sql server
SQL
0 vote172 views1 answer
Monthly Birthday SQL Query
SQL
1 vote169 views1 answer
Sql server reseed single table
SQL
1 vote167 views1 answer
Error code 1055
SQL
0 vote255 views1 answer
Sql developer format sql
SQL
4 votes191 views2 answers
Bulk kill mysql processlist
SQL
0 vote177 views1 answer
How to export only procedures mysql
SQL
-1 vote173 views2 answers
Postgres autoincrement primary key
SQL
0 vote179 views2 answers
Database owner can't create new tables postgres
SQL
7 votes178 views4 answers
What is my mysql version
SQL