Re: Changing Field Ordinal Position
От | Andreas Kretschmer |
---|---|
Тема | Re: Changing Field Ordinal Position |
Дата | |
Msg-id | 20101022174913.GA10242@tux обсуждение исходный текст |
Ответ на | Changing Field Ordinal Position (Chris Campbell <ccampbell@cascadeds.com>) |
Ответы |
Re: Changing Field Ordinal Position
|
Список | pgsql-novice |
Chris Campbell <ccampbell@cascadeds.com> wrote: > Using PostgreSQL 9.0.1 > > > > Hi, is it possible to change the ordinal position of fields in a table, or, > more specifically, be able to specify the ordinal position when adding new > fields to a table. I see that each field has a property called “position” yet No. There is no way to do that, sorry. Consider an other way: specify all columns in the right order in your select-statement. Or create a view with the (for you) right order. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-novice по дате отправления: