Vertica Analytics Platform Version 9.3.x Documentation
Generates a SQL script for recreating a physical schema design on another cluster. This function always attempts to recreate projection statements with
KSAFE clauses, if they exist in the original definitions, or
OFFSET clauses if they do not.
EXPORT_CATALOG ( '[destination]' [, 'scope' ] )
If you omit all parameters,
EXPORT_CATALOG exports to standard output all schemas, tables, constraints, views, and projections to which you have access.
Specifies where to send output, one of the following:
Determines what to export:
Was this topic helpful?