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 vote321 views1 answer
What is common table expression in sql
SQL
1 vote250 views1 answer
Mysql pretty date format
SQL
3 votes257 views1 answer
Fk in insert mysql
SQL
0 vote262 views1 answer
Python connect microsoft sql server
SQL
0 vote250 views1 answer
Mysql find db contarint
SQL
0 vote285 views1 answer
Create table like sql
SQL
0 vote244 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote258 views1 answer
Mysql preg replace
SQL
20 votes274 views6 answers
Mysql reset auto increment
SQL
0 vote264 views1 answer
Sort by
SQL