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

2 votes211 views1 answer
Sql get the name of user pc
SQL
0 vote214 views1 answer
Mysql sql select one day before
SQL
0 vote226 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
-1 vote242 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote244 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote174 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote209 views1 answer
Set all the vluses in calumn in sql to false
SQL
4 votes219 views2 answers
Postgres update single column
SQL
1 vote223 views1 answer
Get parameter value in mysql trigger
SQL
2 votes220 views2 answers
Change varchar length mysql
SQL