Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group