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 vote155 views1 answer
Postgresql export output table as a csv
SQL
0 vote163 views1 answer
Mysql add comment to column
SQL
0 vote206 views1 answer
Download mysql database to excel in android studio
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
36 votes184 views3 answers
Add column in mysq
SQL
0 vote174 views1 answer
How to update sql server version
SQL
-2 votes227 views3 answers
How to fetch first 10 rows in sql
SQL
10 votes177 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote168 views1 answer
Change role postgres
SQL
0 vote184 views1 answer
Dataframe lambda elif
SQL