Is it possible to specify the position of a new column when using alter table to add a column? EG. "alter table myfact add column foo after column bar"?
Unfortunately, that feature isn't currently available in Vertica. There's not currently an efficient way to re-order columns; you can just specify the order in the SELECT statement.
Comments