clone_schema
A PostgreSQL utility that clones an entire schema with all its objects (tables, views, functions, etc.) using a single SQL function.
What is clone_schema?
clone_schema is a PostgreSQL utility function that duplicates an entire database schema, including all its objects like tables, views, functions, and permissions, directly within the database. It solves the problem of needing to use external tools like pg_dump for schema copying, especially in restricted environments such as Amazon RDS. The tool handles complex scenarios including data transfer, DDL generation, and sequence management.
PostgreSQL database administrators and developers working in managed database environments like RDS, who need to quickly duplicate schemas for testing, staging, or migration purposes.
Developers choose clone_schema because it operates entirely within PostgreSQL, eliminating the need for external tools or leaving the database environment. It offers a simple, single-function interface for comprehensive schema cloning with flexible options for data handling, ownership, and permissions.
Overview
Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
