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 vote307 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
5 votes313 views1 answer
Minecraft java port number
SQL
3 votes317 views2 answers
Install mysql powershell
SQL
0 vote336 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote315 views1 answer
Get schema of table sql
SQL
3 votes303 views1 answer
Sql timestamp to date
SQL
1 vote294 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote361 views1 answer
How to check all scheduled jobs in oracle
SQL
5 votes330 views1 answer
Oracle nls session
SQL
49 votes349 views6 answers
Alter table add column
SQL