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

5 votes160 views3 answers
Sql make column nullable
SQL
0 vote152 views1 answer
Where in clause tsql
SQL
0 vote149 views1 answer
Call rest api from postgresql
SQL
0 vote177 views1 answer
Unique element in sql
SQL
0 vote165 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
17 votes161 views2 answers
T_sql contains
SQL
0 vote158 views1 answer
Logtash mysql cofiguration file
SQL
0 vote157 views1 answer
Drop all triggers oracle
SQL
0 vote223 views1 answer
How to add auto increment primary key
SQL
0 vote189 views1 answer
Oracle job session
SQL