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

Szymon Guz <mabewlun@xxxxxxxxx> · Wed, 24 Nov 2010 08:45:59 +0100

On 24 November 2010 08:42, Alexander Farber <alexander.farber@xxxxxxxxx> 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