pgsync
pgsync copied to clipboard
Option to define target DB schema
Hello ,
Thanks for bringing up this exciting data migration tool. Just want to check is there any possibility to define the target schema as well. Since my case schema name is differ in source and target DB'.s
Source - public
Target - schema2
When I am running the below command ..Table is synced in public schema of target db instead of schema2.
pgsync public.table1
I need that too.
I tried working around this by setting the default search_path on the users, but it still fails. Complaining the table doesn't exist in the destination