denishpatel/pg-clone-schema
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/
PLpgSQLMIT
Issues
- 7
- 6
Types are not case sensitive
#148 opened by digisolu - 2
- 1
nextval duplicated in create table statement
#146 opened by MichaelDBA - 1
pg_get_tabledef() problems
#145 opened by MichaelDBA - 1
Add pg_get_tabledef() fix changes
#144 opened by MichaelDBA - 1
Apply pg_get_tabledef() changes to clone_schema
#143 opened by MichaelDBA - 5
sequence problem
#142 opened by MichaelDBA - 23
- 1
- 5
Returning success/error status
#139 opened by adam-hrb - 3
Owner with special characters
#131 opened by gunnareilers - 26
Multiple issues cloning views
#133 opened by samodadela - 2
- 3
Question about 'DATA' copy performace
#137 opened by samodadela - 2
Upgrade to be compatible with PG v17
#138 opened by MichaelDBA - 1
geometry point column not cloned correctly
#136 opened by MichaelDBA - 3
Comparing this approach vs using pg tools?
#134 opened by mobleyc - 1
NOT NULL appended twice to IDENTITY columns
#132 opened by MichaelDBA - 1
Apply fix to pg_get_tabledef()
#130 opened by MichaelDBA - 12
- 6
Not all triggers cloned
#129 opened by mantoze - 5
Problem execution clone schema
#125 opened by mantoze - 3
Error when udt is not in the source or public schema
#127 opened by caparker - 2
- 1
Redundant permissions granted to predefined roles
#123 opened by MichaelDBA - 1
INSERT Problem with Identity columns
#124 opened by MichaelDBA - 9
Sequence owner is lost after second copy
#120 opened by leshik - 7
Syntax error search path
#119 opened by maxfornacon - 17
Error when using in supabase
#113 opened by maxfornacon - 2
- 3
Table permissions for public role invalidly assigned to non-existing "PUBLIC" role
#117 opened by hlampert - 3
Materialized view with index causes error
#116 opened by hlampert - 1
Bug - The triggers have to be cloned only after the eventual tables rows cloning
#111 opened by nikleo-eng - 2
9.6 support?
#106 opened by MichaelDBA - 2
Error with citext and array in the same table
#114 opened by ktowen - 3
- 1
Handle Special Characters in `tb.grantee` Column
#108 opened by alionar - 2
Problem with custom schemas for extensions
#105 opened by MichaelDBA - 0
Problem with sequence ownership for some sequences
#107 opened by leshik - 5
Partitioned Tables
#103 opened by danieluisilva - 4
AWS RDS: COPY to a file is not permitted
#102 opened by ZipBrandon - 5
Clone schema fails when functions are in public
#100 opened by ZipBrandon - 1
Add version to exception output
#101 opened by MichaelDBA - 2
Indexes are cloned to the source tablespace
#99 opened by leshik - 1
materialized views not being populated
#98 opened by MichaelDBA - 1
Add ACL/owner optional parameters
#95 opened by MichaelDBA - 1
- 1
Fix a collation problem in PG15
#96 opened by MichaelDBA - 1
Feature Request: make parameters variable for ease in adding additional ones
#94 opened by MichaelDBA