Copy a table from one schema to another in the same database without using INSERT statement with SEL

I have a table in one schema that is 160 GB and I would like to copy it to another schema. Is there a way other than INSERT statement with SELECT query?? The INSERT statement with SELECT query takes so long to copy. I have not found any other commands that can be used for this purpose. I believe EXPORT TO VERTICA works for the remote database. Please share with me if any of you have ideas

Leave a Comment

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