Use export_objects() to export more than one object?

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Use export_objects() to export more than one object?

Post by Brett » 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 :x

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

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

Post by NorbertKrupa » 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
Checkout vertica.tips for more Vertica resources.

Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

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

Post by Brett » Sun Sep 13, 2015 12:15 am

Hmm. I read that doc several times in the past and think I forgot the syntax :oops: Thanks for your help in reminding me!

Post Reply

Return to “Vertica SQL Functions”