pgsync icon indicating copy to clipboard operation
pgsync copied to clipboard

Option to define target DB schema

Open PGPAWAN opened this issue 1 year ago • 3 comments

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

PGPAWAN avatar Apr 03 '24 18:04 PGPAWAN

I need that too.

LodeSNA avatar May 17 '24 05:05 LodeSNA

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

jas32096 avatar Nov 14 '24 19:11 jas32096