Hey Alexander, Ordinal positions of columns can't be set manually by ALTER TABLE.
2010/11/24 Alexander Farber <alexander.far...@gmail.com> > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- // Dmitriy.
