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 vote125 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote142 views1 answer
Sql oracle update multiple rows
SQL
3 votes112 views2 answers
Postgres download
SQL
0 vote123 views1 answer
Mysql workbench view
SQL
0 vote236 views1 answer
Why do we need data structure in sql
SQL
11 votes130 views2 answers
MySQL DISTINCT
SQL
1 vote113 views1 answer
How refresh navicat tables to see new tables
SQL
6 votes141 views2 answers
Postgresql pg_dump
SQL
0 vote154 views1 answer
Alter owner in PostgreSQL
SQL
2 votes129 views2 answers
Create temporary table in mysql
SQL