We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

Comments

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file