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 vote231 views1 answer
Testing sql queries
SQL
0 vote213 views1 answer
Creation d'un trigger sql
SQL
0 vote202 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote273 views1 answer
Delete from IN subquery
SQL
0 vote203 views2 answers
Replace null with 0 in sql
SQL
1 vote216 views1 answer
Update and replace mysql
SQL
0 vote224 views1 answer
Supprimer les valeur d'une table mysql
SQL
23 votes212 views3 answers
Sql where contains part of string
SQL
1 vote208 views2 answers
Mssql show database size
SQL
1 vote276 views2 answers
Mysql SELECT
SQL