Skip to content

Instantly share code, notes, and snippets.

@gvasquez95
Created April 17, 2018 12:17
Show Gist options
  • Save gvasquez95/c5960c33f91bf46c28b62b2839de54b4 to your computer and use it in GitHub Desktop.
Save gvasquez95/c5960c33f91bf46c28b62b2839de54b4 to your computer and use it in GitHub Desktop.
Sample out for answer at https://dba.stackexchange.com/q/204122
SQL:
SELECT 'ALTER TABLE '
|| table_name
|| ' DISABLE TRIGGER ALL;'
FROM information_schema.TABLES
WHERE table_catalog = 'waypoint';
OUTPUT ROWS:
ALTER TABLE pg_type DISABLE TRIGGER ALL;
ALTER TABLE pg_roles DISABLE TRIGGER ALL;
ALTER TABLE pg_group DISABLE TRIGGER ALL;
ALTER TABLE pg_user DISABLE TRIGGER ALL;
ALTER TABLE pg_rules DISABLE TRIGGER ALL;
ALTER TABLE pg_views DISABLE TRIGGER ALL;
ALTER TABLE pg_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_matviews DISABLE TRIGGER ALL;
ALTER TABLE pg_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_stats DISABLE TRIGGER ALL;
ALTER TABLE pg_settings DISABLE TRIGGER ALL;
ALTER TABLE pg_locks DISABLE TRIGGER ALL;
ALTER TABLE pg_cursors DISABLE TRIGGER ALL;
ALTER TABLE pg_available_extensions DISABLE TRIGGER ALL;
ALTER TABLE pg_available_extension_versions DISABLE TRIGGER ALL;
ALTER TABLE pg_prepared_xacts DISABLE TRIGGER ALL;
ALTER TABLE pg_prepared_statements DISABLE TRIGGER ALL;
ALTER TABLE pg_seclabels DISABLE TRIGGER ALL;
ALTER TABLE pg_timezone_abbrevs DISABLE TRIGGER ALL;
ALTER TABLE pg_timezone_names DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_all_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_xact_all_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_sys_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_xact_sys_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_user_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_xact_user_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_all_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_sys_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_user_tables DISABLE TRIGGER ALL;
ALTER TABLE pg_attribute DISABLE TRIGGER ALL;
ALTER TABLE pg_proc DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_all_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_sys_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_user_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_all_sequences DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_sys_sequences DISABLE TRIGGER ALL;
ALTER TABLE pg_statio_user_sequences DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_activity DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_replication DISABLE TRIGGER ALL;
ALTER TABLE pg_replication_slots DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_database DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_database_conflicts DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_user_functions DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_xact_user_functions DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_archiver DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_bgwriter DISABLE TRIGGER ALL;
ALTER TABLE pg_user_mappings DISABLE TRIGGER ALL;
ALTER TABLE pg_attrdef DISABLE TRIGGER ALL;
ALTER TABLE pg_constraint DISABLE TRIGGER ALL;
ALTER TABLE pg_index DISABLE TRIGGER ALL;
ALTER TABLE pg_operator DISABLE TRIGGER ALL;
ALTER TABLE pg_opfamily DISABLE TRIGGER ALL;
ALTER TABLE pg_opclass DISABLE TRIGGER ALL;
ALTER TABLE pg_am DISABLE TRIGGER ALL;
ALTER TABLE pg_amop DISABLE TRIGGER ALL;
ALTER TABLE pg_amproc DISABLE TRIGGER ALL;
ALTER TABLE pg_language DISABLE TRIGGER ALL;
ALTER TABLE pg_database DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_all_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_sys_indexes DISABLE TRIGGER ALL;
ALTER TABLE pg_stat_user_indexes DISABLE TRIGGER ALL;
ALTER TABLE information_schema_catalog_name DISABLE TRIGGER ALL;
ALTER TABLE applicable_roles DISABLE TRIGGER ALL;
ALTER TABLE administrable_role_authorizations DISABLE TRIGGER ALL;
ALTER TABLE pg_aggregate DISABLE TRIGGER ALL;
ALTER TABLE pg_rewrite DISABLE TRIGGER ALL;
ALTER TABLE pg_trigger DISABLE TRIGGER ALL;
ALTER TABLE pg_event_trigger DISABLE TRIGGER ALL;
ALTER TABLE pg_description DISABLE TRIGGER ALL;
ALTER TABLE pg_cast DISABLE TRIGGER ALL;
ALTER TABLE pg_enum DISABLE TRIGGER ALL;
ALTER TABLE pg_namespace DISABLE TRIGGER ALL;
ALTER TABLE pg_conversion DISABLE TRIGGER ALL;
ALTER TABLE pg_depend DISABLE TRIGGER ALL;
ALTER TABLE pg_db_role_setting DISABLE TRIGGER ALL;
ALTER TABLE pg_tablespace DISABLE TRIGGER ALL;
ALTER TABLE pg_pltemplate DISABLE TRIGGER ALL;
ALTER TABLE pg_auth_members DISABLE TRIGGER ALL;
ALTER TABLE pg_shdepend DISABLE TRIGGER ALL;
ALTER TABLE pg_shdescription DISABLE TRIGGER ALL;
ALTER TABLE pg_ts_config DISABLE TRIGGER ALL;
ALTER TABLE pg_ts_config_map DISABLE TRIGGER ALL;
ALTER TABLE pg_ts_dict DISABLE TRIGGER ALL;
ALTER TABLE pg_ts_parser DISABLE TRIGGER ALL;
ALTER TABLE pg_ts_template DISABLE TRIGGER ALL;
ALTER TABLE pg_extension DISABLE TRIGGER ALL;
ALTER TABLE pg_foreign_data_wrapper DISABLE TRIGGER ALL;
ALTER TABLE pg_foreign_server DISABLE TRIGGER ALL;
ALTER TABLE pg_foreign_table DISABLE TRIGGER ALL;
ALTER TABLE pg_default_acl DISABLE TRIGGER ALL;
ALTER TABLE pg_seclabel DISABLE TRIGGER ALL;
ALTER TABLE pg_shseclabel DISABLE TRIGGER ALL;
ALTER TABLE pg_collation DISABLE TRIGGER ALL;
ALTER TABLE pg_range DISABLE TRIGGER ALL;
ALTER TABLE attributes DISABLE TRIGGER ALL;
ALTER TABLE character_sets DISABLE TRIGGER ALL;
ALTER TABLE check_constraint_routine_usage DISABLE TRIGGER ALL;
ALTER TABLE check_constraints DISABLE TRIGGER ALL;
ALTER TABLE collations DISABLE TRIGGER ALL;
ALTER TABLE collation_character_set_applicability DISABLE TRIGGER ALL;
ALTER TABLE column_domain_usage DISABLE TRIGGER ALL;
ALTER TABLE column_privileges DISABLE TRIGGER ALL;
ALTER TABLE column_udt_usage DISABLE TRIGGER ALL;
ALTER TABLE columns DISABLE TRIGGER ALL;
ALTER TABLE constraint_column_usage DISABLE TRIGGER ALL;
ALTER TABLE constraint_table_usage DISABLE TRIGGER ALL;
ALTER TABLE domain_constraints DISABLE TRIGGER ALL;
ALTER TABLE domain_udt_usage DISABLE TRIGGER ALL;
ALTER TABLE domains DISABLE TRIGGER ALL;
ALTER TABLE enabled_roles DISABLE TRIGGER ALL;
ALTER TABLE key_column_usage DISABLE TRIGGER ALL;
ALTER TABLE parameters DISABLE TRIGGER ALL;
ALTER TABLE referential_constraints DISABLE TRIGGER ALL;
ALTER TABLE role_column_grants DISABLE TRIGGER ALL;
ALTER TABLE routine_privileges DISABLE TRIGGER ALL;
ALTER TABLE role_routine_grants DISABLE TRIGGER ALL;
ALTER TABLE routines DISABLE TRIGGER ALL;
ALTER TABLE schemata DISABLE TRIGGER ALL;
ALTER TABLE sequences DISABLE TRIGGER ALL;
ALTER TABLE sql_implementation_info DISABLE TRIGGER ALL;
ALTER TABLE sql_languages DISABLE TRIGGER ALL;
ALTER TABLE sql_packages DISABLE TRIGGER ALL;
ALTER TABLE table_constraints DISABLE TRIGGER ALL;
ALTER TABLE table_privileges DISABLE TRIGGER ALL;
ALTER TABLE role_table_grants DISABLE TRIGGER ALL;
ALTER TABLE tables DISABLE TRIGGER ALL;
ALTER TABLE triggered_update_columns DISABLE TRIGGER ALL;
ALTER TABLE triggers DISABLE TRIGGER ALL;
ALTER TABLE udt_privileges DISABLE TRIGGER ALL;
ALTER TABLE role_udt_grants DISABLE TRIGGER ALL;
ALTER TABLE usage_privileges DISABLE TRIGGER ALL;
ALTER TABLE role_usage_grants DISABLE TRIGGER ALL;
ALTER TABLE user_defined_types DISABLE TRIGGER ALL;
ALTER TABLE view_column_usage DISABLE TRIGGER ALL;
ALTER TABLE view_routine_usage DISABLE TRIGGER ALL;
ALTER TABLE view_table_usage DISABLE TRIGGER ALL;
ALTER TABLE views DISABLE TRIGGER ALL;
ALTER TABLE data_type_privileges DISABLE TRIGGER ALL;
ALTER TABLE element_types DISABLE TRIGGER ALL;
ALTER TABLE column_options DISABLE TRIGGER ALL;
ALTER TABLE foreign_data_wrapper_options DISABLE TRIGGER ALL;
ALTER TABLE foreign_data_wrappers DISABLE TRIGGER ALL;
ALTER TABLE foreign_server_options DISABLE TRIGGER ALL;
ALTER TABLE foreign_servers DISABLE TRIGGER ALL;
ALTER TABLE foreign_table_options DISABLE TRIGGER ALL;
ALTER TABLE foreign_tables DISABLE TRIGGER ALL;
ALTER TABLE user_mapping_options DISABLE TRIGGER ALL;
ALTER TABLE user_mappings DISABLE TRIGGER ALL;
ALTER TABLE sql_sizing DISABLE TRIGGER ALL;
ALTER TABLE sql_sizing_profiles DISABLE TRIGGER ALL;
ALTER TABLE pg_class DISABLE TRIGGER ALL;
ALTER TABLE pg_largeobject_metadata DISABLE TRIGGER ALL;
ALTER TABLE pg_inherits DISABLE TRIGGER ALL;
ALTER TABLE sql_features DISABLE TRIGGER ALL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment