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 vote168 views1 answer
Add new column in sql with foreign key
SQL
6 votes147 views4 answers
Remove spaces sql server
SQL
0 vote133 views1 answer
Backup a table in sql
SQL
2 votes175 views1 answer
Dbms transaction (psql)
SQL
0 vote191 views1 answer
Table structure in sql
SQL
3 votes211 views3 answers
Mysql get table size
SQL
4 votes136 views1 answer
Sql delete where in select
SQL
1 vote163 views1 answer
Psql search table
SQL
0 vote138 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote126 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL