Please note, that in cases when you can't do simple dump - fix - restore (e.g. in production) you can always create view(s) with ordinal positions of columns convenient for you.
2010/11/24 Dmitriy Igrishin <dmit...@gmail.com> > 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. > > > -- // Dmitriy.
