Import all tables from one schema to another schema - Redshift

import_schema_to_schema.sql

SELECT 'drop table '||n.nspname ||'.'|| c.relname||' CASCADE;' as "Name" 
       FROM pg_catalog.pg_class c
              LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
                     WHERE c.relkind IN ('r','v','S','')
                                  AND n.nspname = 'destination_schema';

SELECT 'create table '||n.nspname ||'.'|| c.relname||' as select * from source_schema.' || c.relname||';' as "Name"                        
       FROM pg_catalog.pg_class c
              LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
                     WHERE c.relkind IN ('r','v','S','')
                                  AND n.nspname = 'destination_schema';