SHOW EVENTS

Function

SHOW EVENTS displays basic information about all scheduled tasks in a specified schema.

Precautions

Operations related to scheduled events are supported only when sql_compatibility is set to 'B'.

Syntax

SHOW EVENTS
    [{FROM | IN} schema_name]
    [LIKE 'pattern' | WHERE condition]

Parameter Description

• {FROM | IN} schema_name

  Specifies the schema to be queried. By default, the current schema is queried.

• LIKE 'pattern'

  Matches a scheduled task by name. If this parameter is not specified, all scheduled tasks in the current schema are printed.

• WHERE condition

  Forms an expression for row selection to narrow down the query range of SHOW EVENTS. condition indicates any expression that returns a value of Boolean type. Rows that do not meet this condition will not be retrieved.

Examples

--View information about all scheduled tasks queried through pattern matching **'_e'** in the **event_a** schema.
openGauss=# SHOW EVENTS IN event_a LIKE '_e';