IMPORT_DIRECTED_QUERIES

Imports to the database catalog directed queries from a SQL file that was generated by EXPORT_DIRECTED_QUERIES. If no directed queries are specified, Vertica lists all directed queries in the SQL file.

Syntax

IMPORT_DIRECTED_QUERIES( 'export-file'[, 'directed-query-name[,…]' ] )

Parameters

export‑file A SQL file generated by EXPORT_DIRECTED_QUERIES. When you run this file, Vertica creates the specified directed queries in the current database catalog.
directed‑query‑name

The name of a directed query that is defined in export‑file. You can specify multiple comma-delimited directed query names.

If you omit this parameter, Vertica lists the names of all directed queries in export‑file.

Privileges

Superuser

See Also