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

5 votes274 views1 answer
Sql asynchronous stored procedure call
SQL
11 votes316 views2 answers
Oracle saurce code
SQL
12 votes288 views2 answers
Delete all nodes neo4j
SQL
4 votes281 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote300 views1 answer
Ajax error exception handeling
SQL
6 votes295 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote319 views2 answers
Amazon linux postgresql client
SQL
2 votes275 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote305 views1 answer
Oracle drop type
SQL
0 vote270 views1 answer
Sql right characters
SQL