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

0 vote155 views1 answer
Rabbitmq ui not working
SQL
6 votes172 views1 answer
To count number of rows in SQL table
SQL
0 vote172 views1 answer
Mysqldump: error:
SQL
6 votes1.3K views1 answer
Sql select second max
SQL
0 vote161 views2 answers
Select last 30 days sql
SQL
0 vote164 views1 answer
Php select data from mysql database without column name
SQL
0 vote153 views1 answer
On sql table data exists
SQL
3 votes144 views2 answers
Update Query in SQL Server
SQL
11 votes165 views3 answers
Sql line numbers
SQL
0 vote222 views1 answer
Trigger
SQL