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

1 vote306 views4 answers
Fatal database postgres does not exist
SQL
4 votes330 views1 answer
Change nls_date_format
SQL
6 votes315 views1 answer
Oracle rank() over (partition)
SQL
0 vote335 views1 answer
Two inner joins sql
SQL
0 vote332 views1 answer
Sql server union if table exist
SQL
0 vote396 views1 answer
Select * from mysql.proc
SQL
1 vote351 views1 answer
How to select random rows from a table
SQL
1 vote331 views2 answers
Rebuild index sql server
SQL
0 vote327 views1 answer
Mysql find db contarint
SQL
0 vote364 views1 answer
Postgres list users and roles
SQL