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