Skip to content

Instantly share code, notes, and snippets.

@dstrbad

dstrbad/import_schema_to_schema.sql

Forked from marinbek/import_schema_to_schema.sql
Created June 2, 2014 09:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dstrbad/cc7e3b3a05a80efc300d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dstrbad/cc7e3b3a05a80efc300d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment