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

14 votes144 views3 answers
Alter foreign key
SQL
10 votes145 views1 answer
Oracle object dependencies
SQL
1 vote159 views2 answers
Sql multiline comment
SQL
1 vote150 views1 answer
Convert varchar to int in sqlite
SQL
0 vote190 views1 answer
Sqlalchemy orm duplicate
SQL
7 votes150 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote140 views1 answer
Alphabetical order mysql
SQL
0 vote180 views1 answer
For select oracle
SQL
0 vote160 views2 answers
What is the default password for sql server sa
SQL
0 vote146 views1 answer
Sql reverse order of results
SQL