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

1 vote262 views1 answer
Get table which have specific columns in mysql
SQL
2 votes268 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote274 views1 answer
Sql server create constraint
SQL
0 vote249 views1 answer
Sql python hwo to pass a list in paramerter
SQL
1 vote263 views1 answer
Mysql f# examples
SQL
0 vote330 views1 answer
Oracle simple quote
SQL
8 votes286 views1 answer
Ltrim sql
SQL
0 vote249 views1 answer
Sql server current time without date
SQL
6 votes311 views5 answers
Oracle list tablespaces
SQL
5 votes267 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL