GaussDB-MY_TRIGGERS
MY_TRIGGERS displays information about the triggers owned by the current user. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | character varying(128) | Trigger owner. |
| trigger_name | character varying(64) | Trigger name. |
| trigger_type | character varying | Trigger type, which can be before statement, before each row, after statement, after each row, or instead of. |
| triggering_event | character varying | Event that triggers a trigger. The value can be update, insert, delete, or truncate. |
| table_owner | character varying(64) | Owner of the table that defines a trigger. |
| base_object_type | character varying(18) | Basic object type of a trigger, which can be table or view. |
| table_name | character varying(64) | Name of the table or view that defines a trigger. |
| column_name | character varying(4000) | Not supported. Set it to NULL. |
| referencing_name | character varying(422) | Not supported. Set it to referencing new as new old as old. |
| when_clause | character varying(4000) | Content of when. TRUE must be evaluated as TRIGGER_BODY to execute. |
| status | character varying(64) | - O: The trigger is enabled in origin or local mode. |
- D: The trigger is disabled.
- R: The trigger is enabled in replica mode.
- A: The trigger is always enabled. | | description | character varying(4000) | Trigger description, which is used to rebuild a trigger creation statement. | | action_type | character varying(11) | Action type of a trigger, which only supports call. | | trigger_body | text | Statement executed when a trigger is triggered. | | crossedition | character varying(7) | Not supported. Set it to NULL. | | before_statement | character varying(3) | Not supported. Set it to NULL. | | before_row | character varying(3) | Not supported. Set it to NULL. | | after_row | character varying(3) | Not supported. Set it to NULL. | | after_statement | character varying(3) | Not supported. Set it to NULL. | | instead_of_row | character varying(3) | Not supported. Set it to NULL. | | fire_once | character varying(3) | Not supported. Set it to NULL. | | apply_server_only | character varying(3) | Not supported. Set it to NULL. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
