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

2 votes354 views1 answer
Q operator in sql
SQL
2 votes348 views1 answer
Oracle generated column
SQL
0 vote325 views1 answer
PSQL qith variables
SQL
1 vote343 views1 answer
Postgresql datetrunc too slow
SQL
48 votes388 views3 answers
Psql create database
SQL
0 vote367 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote383 views1 answer
Mysql workbench format date
SQL
1 vote362 views1 answer
Sql set auto increment back to 0
SQL
8 votes323 views1 answer
Oracle add month
SQL
10 votes329 views1 answer
Oracle all_dependencies
SQL