DROP FILTER

Drops a User Defined Load Filter function from the Vertica catalog.

Syntax

DROP FILTER [[database.]schema.]filter()

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
filter()

Specifies the filter function to drop. You must append empty parentheses to the function name.

Privileges

Non-superuser:

Example

The following command drops the Iconverter filter function::

=> drop filter Iconverter();
DROP FILTER

See Also