Name: | triggers |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
trigger_catalog | sql_identifier | -1 |
|
trigger_schema | sql_identifier | -1 |
|
trigger_name | sql_identifier | -1 |
|
event_manipulation | character_data | -1 |
|
event_object_catalog | sql_identifier | -1 |
|
event_object_schema | sql_identifier | -1 |
|
event_object_table | sql_identifier | -1 |
|
action_order | cardinal_number | -1 |
|
action_condition | character_data | -1 |
|
action_statement | character_data | -1 |
|
action_orientation | character_data | -1 |
|
condition_timing | character_data | -1 |
|
condition_reference_old_table | sql_identifier | -1 |
|
condition_reference_new_table | sql_identifier | -1 |
|
condition_reference_old_row | sql_identifier | -1 |
|
condition_reference_new_row | sql_identifier | -1 |
|
created | time_stamp | -1 |
CREATE VIEW triggers AS
SELECT (current_database())::sql_identifier AS trigger_catalog, (n.nspname)::sql_identifier AS trigger_schema, (t.tgname)::sql_identifier AS trigger_name, (em.text)::character_data AS event_manipulation, (current_database())::sql_identifier AS event_object_catalog, (n.nspname)::sql_identifier AS event_object_schema, (c.relname)::sql_identifier AS event_object_table, (NULL::integer)::cardinal_number AS action_order, (NULL::character varying)::character_data AS action_condition, ("substring"(pg_get_triggerdef(t.oid), ("position"("substring"(pg_get_triggerdef(t.oid), 48), 'EXECUTE PROCEDURE'::text) + 47)))::character_data AS action_statement, (CASE WHEN (((t.tgtype)::integer & 1) = 1) THEN 'ROW'::text ELSE 'STATEMENT'::text END)::character_data AS action_orientation, (CASE WHEN (((t.tgtype)::integer & 2) = 2) THEN 'BEFORE'::text ELSE 'AFTER'::text END)::character_data AS condition_timing, (NULL::character varying)::sql_identifier AS condition_reference_old_table, (NULL::character varying)::sql_identifier AS condition_reference_new_table, (NULL::character varying)::sql_identifier AS condition_reference_old_row, (NULL::character varying)::sql_identifier AS condition_reference_new_row, (NULL::timestamp with time zone)::time_stamp AS created FROM pg_namespace n, pg_class c, pg_trigger t, ((SELECT 4, 'INSERT' UNION ALL SELECT 8, 'DELETE') UNION ALL SELECT 16, 'UPDATE') em(num, text) WHERE ((((((n.oid = c.relnamespace) AND (c.oid = t.tgrelid)) AND (((t.tgtype)::integer & em.num) <> 0)) AND (NOT t.tgisconstraint)) AND (NOT pg_is_other_temp_schema(n.oid))) AND (((((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'INSERT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)) OR has_table_privilege(c.oid, 'DELETE'::text)) OR has_table_privilege(c.oid, 'REFERENCES'::text)) OR has_table_privilege(c.oid, 'TRIGGER'::text)));
ALTER TABLE information_schema.triggers OWNER TO postgres;
See Also
List of views