Show information about a stored procedure

You can use the SHOW PROCEDURE command to display information about a stored procedure.

A sample command follows for the example customer procedure:

MYDB.TESTSCH(USR)=> SHOW PROCEDURE customer;
 RESULT  | PROCEDURE | BUILTIN | ARGUMENTS
---------+-----------+---------+-----------
 INTEGER | CUSTOMER  | f       | ()
(1 row)

The sample output shows the return value (RESULT), the procedure name, f (false) to indicate that this is a user-defined procedure (not a built-in or system-supplied procedure), and the argument list for the procedure (an empty list in this example).

The command displays information for any procedures with names that begin with the specified characters. For example, if you have two procedures named customer and customerid, this example command displays information for both procedures.

The command also offers a VERBOSE mode that displays more information about the procedure, including the procedure body, comments (if supplied), owner, execution user, and other information. If the procedure is obfuscated, the procedure body is not in clear text; it is in an unreadable format.