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 vote378 views1 answer
Mysql strict_trans_tables
SQL
8 votes349 views1 answer
Alter tablespace add datafile
SQL
10 votes380 views3 answers
Join multiple tables sql
SQL
0 vote371 views1 answer
Sql #region
SQL
5 votes334 views1 answer
Mysql select greater than yesterday
SQL
0 vote348 views1 answer
How to avoid duplicate records in sqlite
SQL
6 votes358 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
3 votes353 views1 answer
Oracle function
SQL
1 vote349 views1 answer
Return size of tables in mysql
SQL
2 votes358 views1 answer
Compare date in sql
SQL