alter table, placing the new column after the id

From: "Zouari Fourat" <fourat(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: alter table, placing the new column after the id
Date: 2006-02-28 19:13:03
Message-ID: 621eda8a0602281113o459a1a1dt437c58e12658d187@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
When trying to alter my table to add a column, it will be added at the
end of the table, i want to get my column after a given column name,
for example get my table like this :

ID
firstname
lastname
<--- my new added column here
adrress
country
<--- not here !

how to get it ?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-02-28 19:18:38 Re: alter table, placing the new column after the id
Previous Message Lane Van Ingen 2006-02-28 18:37:18 Re: install