Re: alter table add column - specify where the column will go?

On 24 November 2010 08:42, Alexander Farber <alexander(dot)farber(at)gmail(dot)com>wrote:

> Hello,
>
> is there a syntax to add a column not at the last place, but
> somewhere inbetween or do I have to dump/restore the table?
>
> For example if I'd like to add last_logout right after last_login:
>
> \d pref_users;
> Table "public.pref_users"
> Column | Type | Modifiers
> ------------+-----------------------------+---------------
> id | character varying(32) | not null
> first_name | character varying(32) |
> last_name | character varying(32) |
> female | boolean |
> avatar | character varying(128) |
> city | character varying(32) |
> lat | real |
> lng | real |
> last_login | timestamp without time zone | default now()
> last_ip | inet |
> medals | smallint | default 0
>
> Thank you
> Alex
>
>
.... no

Why do you want to do anything like that?

regards
Szymon Guz