Skip to content

Instantly share code, notes, and snippets.

@briandignan
briandignan / save_restore_dependencies.sql
Last active June 25, 2024 06:21 — forked from claudep/save_restore_dependencies.sql
Changed types for compatibility with PG12. Added save/restore for indexes/rules
create table if not exists deps_saved_ddl
(
deps_id serial primary key,
deps_view_schema name,
deps_view_name name,
deps_ddl_to_run text
);
create or replace function deps_save_and_drop_dependencies(p_view_schema name, p_view_name name) returns void as
$$