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 vote180 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
11 votes169 views2 answers
Set default column value sql
SQL
3 votes167 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote178 views1 answer
Create table split string function in sql server
SQL
5 votes182 views2 answers
Mysql import gzip db
SQL
13 votes183 views2 answers
Sql join 3 tables
SQL
1 vote173 views1 answer
What is intersect
SQL
0 vote189 views1 answer
Implicit inner join table alias
SQL
6 votes164 views1 answer
Postgresql add enum value
SQL
0 vote181 views1 answer
GROUP BY postgres
SQL