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 vote139 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote162 views1 answer
Php insert null mysql
SQL
0 vote123 views3 answers
Joins and views sql
SQL
0 vote128 views2 answers
Postgres default user
SQL
0 vote136 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
4 votes138 views1 answer
Wilayah indonesia sql
SQL
0 vote138 views2 answers
How to update the multiple rows in sql
SQL
2 votes154 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes128 views3 answers
Postgresql dump and restore db
SQL
3 votes163 views2 answers
Oracle sql first day of month
SQL