Is it possible to specify column position when using "alter table add column"?

EugeneAbovsky

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"?

[Deleted User]

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.