Skip to content

Instantly share code, notes, and snippets.

View claudep's full-sized avatar

Claude Paroz claudep

View GitHub Profile
@claudep
claudep / save_restore_dependencies.sql
Last active February 23, 2024 06:09 — forked from mateuszwenus/save_restore_dependencies.sql
Replaced quotes by quote_ident
create table if not exists deps_saved_ddl
(
deps_id serial primary key,
deps_view_schema varchar(255),
deps_view_name varchar(255),
deps_ddl_to_run text
);
create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as
$$