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

33 votes355 views6 answers
Change column name in mysql
SQL
4 votes314 views1 answer
Mac install mysql
SQL
0 vote340 views1 answer
Ksql quickstart docker
SQL
0 vote342 views1 answer
How to use select union and loop
SQL
0 vote340 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote341 views1 answer
Placements hackerrank solution
SQL
1 vote343 views1 answer
Import sql file mysql commadn line
SQL
7 votes345 views6 answers
Reset identity column in sql server
SQL
3 votes326 views1 answer
Oracle user quota unlimited
SQL
0 vote320 views1 answer
Mariadb LOAD DATA INFILE
SQL