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
Creating a simple notify in postgresql
SQL
9 votes249 views3 answers
Mysql show table column full description
SQL
0 vote221 views1 answer
How many columns can be used for creating index?
SQL
19 votes249 views5 answers
Date between in mysql
SQL
1 vote250 views1 answer
Search for replace in mysql
SQL
3 votes259 views2 answers
How to force truncate a table in mysql
SQL
1 vote258 views1 answer
Dropping a constraint in ms sql
SQL
1 vote243 views1 answer
Get create table query existing table mysql
SQL
9 votes268 views3 answers
Pyodbc connect to sql server
SQL
8 votes245 views5 answers
Grant permission in postgres
SQL