Dnia wtorek, 5 kwietnia 2005 20:13, Tom Lane napisał: > somee <grzegorz.przezdziecki@xxxxxxxxxxxxxxxx> writes: > > I want to change column order in select * from table instruction; > > I can do that changing attnum but I don't know it is safely or not for > > system. > > It won't work and will likely crash the backend. > Even if I will do like this and for ever?? 1. attnum will be unique and greater than 0 2. no holes in attnum numeric 3. Make change 4. restart postgresql > regards, tom lane Best Regards -- Grzegorz Przeździecki www.PolskieSklepy.pl kom. +48.606.822.506 gg:3701851 skype: grzegorz.przezdziecki ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly