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 vote249 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
5 votes241 views2 answers
Create function postgresql
SQL
0 vote226 views1 answer
Postgresql create user roles
SQL
0 vote224 views2 answers
Sql drop view if exists
SQL
1 vote218 views1 answer
Mysql view command
SQL
2 votes215 views2 answers
Insert all in sql
SQL
-1 vote220 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
1 vote212 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote241 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
28 votes231 views4 answers
Show tables mysql
SQL