EXPORT_OBJECTS
This function and EXPORT_CATALOG return equivalent output.
Generates a SQL script you can use to recreate non-virtual catalog objects on another cluster.
The SQL script conforms to the following requirements:
- Only includes objects to which the user has access.
- Orders CREATE statements according to object dependencies so they can be recreated in the correct sequence. For example, if a table is in a non-PUBLIC schema, the required CREATE SCHEMA statement precedes the CREATE TABLE statement. Similarly, a table's CREATE ACCESS POLICY statement follows the table's CREATE TABLE statement.
- If possible, creates projections with their KSAFE clause, if any, otherwise with their OFFSET clause.
Syntax
EXPORT_OBJECTS( ['[destination]' [, '[scope]'] [, 'mark-ksafe']] )
Parameters
If you omit all parameters, this function exports to standard output all objects to which you have access.
destination |
Specifies where to send output, one of the following:
|
scope |
Specifies one or more objects to export as a comma-delimited list: [database.]schema[.object][,...]
|
mark-ksafe |
Boolean argument, specifies whether to include a MARK_DESIGN_KSAFE statement in the generated script with the correct K-safe value for the database:
|
Privileges
None
Example
See Exporting Objects.