Re: Add Column BEFORE/AFTER another column
От | Matthew |
---|---|
Тема | Re: Add Column BEFORE/AFTER another column |
Дата | |
Msg-id | 46CF4B1A.8020000@voilaip.com обсуждение исходный текст |
Ответ на | Re: Add Column BEFORE/AFTER another column (Bill Moran <wmoran@potentialtech.com>) |
Ответы |
Re: Add Column BEFORE/AFTER another column
Re: Add Column BEFORE/AFTER another column Re: Add Column BEFORE/AFTER another column |
Список | pgsql-general |
Hey Bill, > It does not. Bummer. > To get your columns in a specific order, specify the column names in > that order in your SELECT statement. The SQL standard doesn't provide > for any other way to guarantee column order, and neither does Postgres. Yes, I realize this and we do identify our columns during select statements, but when you look at a table using a tool like phpPGAdmin or pgAdmin3, the columns are displayed in some defined order. It's much easier to see your data/columns in some logical order (ie: all the cost columns next to each other). Thanks, Matthew
В списке pgsql-general по дате отправления: