Generates a SQL script you can use to recreate non-virtual catalog objects on another cluster. The following requirements apply:
EXPORT_OBJECTSonly exports objects to which the user has access.
EXPORT_OBJECTSexports objects in order dependency for correct recreation. When you run the script on another cluster, Vertica creates all referenced objects before their dependent objects.
EXPORT_OBJECTSalways tries to recreate projection statements with their
KSAFEclause, if any, otherwise with their
EXPORT_OBJECTS( '[destination]' [, 'scope' ] [, 'ksafe' ] )
Specifies where to send output, one of the following:
Specifies one or more objects to export, as follows:
If set to an empty string, Vertica exports all objects to which the user has access, including constraints.
If you specify a schema, Vertica exports all objects in that schema.
If you specify a database, it must be the current database.
Specifies whether to include a
See Exporting Objects.