Redshift Observatory

System Table Tracker

System view information_schema.triggered_update_columns version 1.0.45698 / 2023-01-27

schema	name	column	data type
information_schema	triggered_update_columns	event_object_catalog	sql_identifier
information_schema	triggered_update_columns	event_object_column	sql_identifier
information_schema	triggered_update_columns	event_object_schema	sql_identifier
information_schema	triggered_update_columns	event_object_table	sql_identifier
information_schema	triggered_update_columns	trigger_catalog	sql_identifier
information_schema	triggered_update_columns	trigger_name	sql_identifier
information_schema	triggered_update_columns	trigger_schema	sql_identifier

View Text

SELECT CAST(current_database() AS information_schema.sql_identifier) AS trigger_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS trigger_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS trigger_name,
       CAST(current_database() AS information_schema.sql_identifier) AS event_object_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS event_object_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS event_object_table,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS event_object_column
WHERE FALSE

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers