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 vote378 views1 answer
SQL check if record exist
SQL
0 vote346 views2 answers
Postgresql get last day of month
SQL
0 vote396 views1 answer
GROUP BY postgres
SQL
0 vote370 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote433 views1 answer
How to get number of months between 2 dates sql server
SQL
11 votes337 views2 answers
Import sql file laravel cmd
SQL
0 vote389 views1 answer
Oracle list datafiles
SQL
0 vote339 views1 answer
Pl sql search saurce code
SQL
1 vote357 views1 answer
List all triggers in SQL Server
SQL
0 vote373 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL