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 votes124 views2 answers
Sql paging query
SQL
10 votes120 views2 answers
Sql merge statement
SQL
0 vote143 views1 answer
Redshift running queries
SQL
0 vote130 views1 answer
ORA-13717
SQL
0 vote132 views1 answer
Postgres 11 add primary key
SQL
0 vote132 views2 answers
What is 1=2 in sql
SQL
0 vote125 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote141 views2 answers
Sql max count
SQL
2 votes128 views6 answers
In in sql
SQL
0 vote128 views1 answer
Sql count * vs count 1
SQL