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 vote201 views1 answer
Learnxinyminutes sql
SQL
0 vote203 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote188 views1 answer
Flask sqlalchemy default value
SQL
0 vote186 views1 answer
Where date major today mysql
SQL
14 votes199 views4 answers
Online sql compiler
SQL
0 vote182 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote193 views2 answers
How to find max and min salary in sql
SQL
3 votes187 views3 answers
Create a view postgres
SQL
1 vote232 views1 answer
Postgresql where datetrunc month and year equal
SQL
1 vote204 views1 answer
Spark sql convert string to date
SQL