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

0 vote260 views1 answer
Ora 00001 error catch plsql
SQL
10 votes275 views1 answer
Oracle all_dependencies
SQL
1 vote213 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
9 votes208 views4 answers
Postgresql export database
SQL
1 vote195 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
-3 votes188 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote207 views1 answer
Table valued functions in sql
SQL
1 vote238 views1 answer
Oracle columns table
SQL
0 vote207 views1 answer
To_date sql
SQL
0 vote200 views1 answer
Date on SQL
SQL