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 vote177 views1 answer
Sql server count all tables rows
SQL
0 vote176 views2 answers
Starting mysql service from mac
SQL
1 vote181 views1 answer
Sql how to replace full stop
SQL
0 vote227 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote175 views1 answer
Mariadb select limit offset
SQL
0 vote182 views1 answer
Oracle query to find schema you are working on
SQL
0 vote202 views2 answers
Postgres isnull
SQL
0 vote165 views1 answer
Check index sql server
SQL
0 vote175 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote181 views1 answer
Write SQL in ruby on rails
SQL