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
Examples
See Importing Directed Queries.