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 vote310 views2 answers
Sql join on wildcard
SQL
-1 vote306 views2 answers
Get day in sql
SQL
0 vote322 views1 answer
Cross apply top for each row t1
SQL
3 votes319 views2 answers
Tsql join multiple record in one string
SQL
0 vote349 views1 answer
Hashpass
SQL
3 votes359 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote361 views1 answer
What is metadata in sql
SQL
3 votes309 views1 answer
Mssql remove column
SQL
0 vote310 views1 answer
How to combine rows in sql server procedure
SQL
3 votes311 views2 answers
Df to sql pandas sql achemy
SQL