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

3 votes245 views3 answers
Mysqldump: couldn
SQL
0 vote258 views1 answer
Mysql Error Code: 1005
SQL
0 vote244 views1 answer
Get all employees if name ends with in sql
SQL
4 votes245 views1 answer
SQL order random
SQL
-1 vote253 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote284 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote274 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote298 views2 answers
How to get max from each department in sql
SQL
1 vote275 views1 answer
Where database run
SQL
0 vote264 views1 answer
SQL loop with cursor
SQL