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

2 votes141 views1 answer
Drop table purge
SQL
5 votes151 views3 answers
Oracle first day of last year
SQL
0 vote148 views1 answer
Assign value to var in SQL
SQL
11 votes236 views1 answer
Oracle insert from select
SQL
0 vote166 views1 answer
Postgres grep entire database
SQL
12 votes146 views2 answers
Delete entries in postgresql
SQL
0 vote150 views1 answer
Separator mysql
SQL
3 votes155 views2 answers
Postgres show table schema
SQL
-1 vote182 views1 answer
How to Activate the database
SQL
0 vote153 views1 answer
Mysql set variable to today's date
SQL