USER_PROCEDURES

Provides information about external procedures that have been defined for Vertica. User see only the procedures they can execute.

Column Name Data Type Description 
PROCEDURE_NAME

VARCHAR

The name given to the external procedure through the CREATE PROCEDURE statement.

 
PROCEDURE_ARGUMENTS

VARCHAR

Lists arguments for the external procedure.

 
SCHEMA_NAME

VARCHAR

Indicates the schema in which the external procedure is defined.

Example

=> SELECT * FROM user_procedures;
 procedure_name | procedure_arguments | schema_name
----------------+---------------------+-------------
 helloplanet    | arg1 Varchar        | public
(1 row)