| PostgreSQL 8.3.16 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 33. The Information Schema | Fast Forward | Next |
The view triggers contains all triggers defined in the current database on tables that the current user owns or has some privilege on.
Table 33-40. 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 | Applies to a feature not available in PostgreSQL |
| 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) |
| condition_timing | character_data | Time at which the trigger fires (BEFORE or AFTER) |
| condition_reference_old_table | sql_identifier | Applies to a feature not available in PostgreSQL |
| condition_reference_new_table | sql_identifier | Applies to a feature not available in PostgreSQL |
| condition_reference_old_row | sql_identifier | Applies to a feature not available in PostgreSQL |
| condition_reference_new_row | sql_identifier | Applies to a feature not available in PostgreSQL |
| created | time_stamp | Applies to a feature not available in PostgreSQL |
Triggers in PostgreSQL have two incompatibilities with the SQL standard that affect the representation
| PostgreSQL 8.3.16 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Appendix E. Release Notes | Fast Forward | Next |
Release date: 2001-05-05
This has a variety of fixes from 7.1.
A dump/restore is not required for those running 7.1.