The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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