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

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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file