Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
drop foreign schema and reimport
do
$$
declare
l_rec record;
begin
for l_rec in (select foreign_table_schema, foreign_table_name
from information_schema.foreign_tables) loop
execute format('drop foreign table %I.%I cascade', l_rec.foreign_table_schema, l_rec.foreign_table_name);
end loop;
end;
$$
IMPORT FOREIGN SCHEMA public
EXCEPT ( ar_internal_metadata, g5_authenticatable_roles, g5_authenticatable_users, job_logs, schema_migrations )
FROM SERVER \"#{ENV['DW_DBNAME']}\"
INTO public;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.