The Vertica Database Forums

Posted: **Fri Sep 11, 2015 3:07 pm**

Hello,

Being that that the function to export objects is plural (export_objects) I thought we would be able to export more than one object at a time.

I tried this:

Code: Select all

dbadmin=> select export_objects('','table1', 'table2');
ERROR 3680:  Invalid input syntax for boolean: "table2"

No luck

Posted: **Fri Sep 11, 2015 6:20 pm**

The use specifies using a comma-delimited list:

Code: Select all

SELECT EXPORT_OBJECTS('', 'public.inventory_fact,public.warehouse_dimension');

Documentation

Posted: **Sun Sep 13, 2015 12:15 am**

Hmm. I read that doc several times in the past and think I forgot the syntax

Thanks for your help in reminding me!

The Vertica Database Forums

Use export_objects() to export more than one object?

Use export_objects() to export more than one object?

Re: Use export_objects() to export more than one object?

Re: Use export_objects() to export more than one object?