Repository metrics
- Stars
- (1,151 stars)
- PR merge metrics
- (PR metrics pending)
Description
Is your feature request related to a problem? Please describe.
I have many Postgres databases that I want to copy to a single "data warehouse". I want each Postgres DB to have the tables from its public schema copied to a schema in the data warehouse DB named by the source app, ex: public.users -> app1.users.
Right now I'm doing this using Sling, which is great! But I would love to switch to pgstream to have faster, more intelligent duplication.
To my understanding, this is not currently supported in pgstream because it's missing schema name transformations (let me know if I'm wrong, I just recently learned about pgstream!).
Describe the solution you'd like
Ability to set schema_mapping in configuration to set up schema name transformations.
Describe alternatives you've considered
Anything that would let me achieve public.users -> app1.users.
Additional context N/A