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 vote196 views1 answer
Mysql terminal list table
SQL
1 vote208 views3 answers
SELECT * FROM
SQL
0 vote195 views1 answer
How to get data between a last week in mysql
SQL
8 votes226 views1 answer
Mysql limit rows
SQL
0 vote196 views1 answer
ORACLE PARSE STRING
SQL
5 votes198 views2 answers
Get columns number sql
SQL
36 votes216 views3 answers
Add column in mysq
SQL
0 vote187 views1 answer
Drop check command
SQL
0 vote200 views1 answer
Excel vba import data to sql server
SQL
0 vote193 views1 answer
Java input type sql date
SQL