alter table, placing the new column after the id - Mailing list pgsql-novice

From Zouari Fourat
Subject alter table, placing the new column after the id
Date
Msg-id 621eda8a0602281113o459a1a1dt437c58e12658d187@mail.gmail.com
Whole thread Raw
Responses Re: alter table, placing the new column after the id
List 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 ?

pgsql-novice by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: Re: install
Next
From: Sean Davis
Date:
Subject: Re: alter table, placing the new column after the id