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 vote136 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote124 views1 answer
Postgres convert exisiting column to text
SQL
0 vote118 views1 answer
C# get sql min date
SQL
5 votes136 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote81 views2 answers
Get date from datetime postgresql
SQL
2 votes130 views1 answer
Docker run postgres locally
SQL
3 votes143 views1 answer
Apex set debug level
SQL
1 vote132 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote108 views3 answers
Remove folders from remote git
SQL
1 vote133 views1 answer
Mysql view current queries
SQL