Postgres-XC 1.0.3 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 33. The Information Schema | Fast Forward | Next |
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly.
The view triggers contains all triggers defined in the current database on tables and views that the current user owns or has some non-SELECT privilege on.
Table 33-50. triggers Columns
Name | Data Type | Description |
---|---|---|
trigger_catalog | sql_identifier | Name of the database that contains the trigger (always the current database) |
trigger_schema | sql_identifier | Name of the schema that contains the trigger |
trigger_name | sql_identifier | Name of the trigger |
event_manipulation | character_data | Event that fires the trigger (INSERT, UPDATE, or DELETE) |
event_object_catalog | sql_identifier | Name of the database that contains the table that the trigger is defined on (always the current database) |
event_object_schema | sql_identifier | Name of the schema that contains the table that the trigger is defined on |
event_object_table | sql_identifier | Name of the table that the trigger is defined on |
action_order | cardinal_number | Not yet implemented |
action_condition | character_data | WHEN condition of the trigger, null if none (also null if the table is not owned by a currently enabled role) |
action_statement | character_data | Statement that is executed by the trigger (currently always EXECUTE PROCEDURE function(...)) |
action_orientation | character_data | Identifies whether the trigger fires once for each processed row or once for each statement (ROW or STATEMENT) |
action_timing | character_data | Time at which the trigger fires (BEFORE, AFTER, or INSTEAD OF) |
action_reference_old_table | sql_identifier | Applies to a feature not available in PostgreSQL |
action_reference_new_table | sql_identifier | Applies to a feature not available in PostgreSQL |
action_reference_old_row | sql_identifier | Applies to a feature not available in PostgreSQL |
action_reference_new_row | sql_identifier | Applies to a feature not available in PostgreSQL |
created | time_stamp | Applies to a feature not available in PostgreSQL |
Note: Prior to PostgreSQL 9.1, this view's columns action_timing, action_reference_old_table, action_reference_new_table, action_reference_old_row, and action_reference_new_row were named condition_timing, condition_reference_old_table, condition_reference_new_table, condition_reference_old_row, and condition_reference_new_row respectively. That was how they were named in the SQL:1999 standard. The new naming conforms to SQL:2003 and later.