drop foreign schema and reimport

drop_foreign_tables_and_reimport.sql

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;