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