Altering a table - positioning new columns
| От | Chris Boget |
|---|---|
| Тема | Altering a table - positioning new columns |
| Дата | |
| Msg-id | 023c01c2c087$53a5d4d0$8c01a8c0@ENTROPY обсуждение исходный текст |
| Ответы |
Re: Altering a table - positioning new columns
Re: Altering a table - positioning new columns Re: Altering a table - positioning new columns |
| Список | pgsql-general |
In MySQL, when adding a new column to a table, you could position it relative to another column already in the DB. IOW, you could do something like this: ALTER TABLE blah ADD COLUMN newcol AFTER anothercol. Is something like this possible in PG? Or are _all_ new columns added to the end of the column list? I've searched through the docs and couldn't find that this was possible and some tests have come up with errors. That said, I'm still new enough to where I can't be sure I'm doing it the right way for PG and am hoping one of you guys can give me a definitive yes or no. thnx, Chris
В списке pgsql-general по дате отправления: