👋 Hi everyone!, I’m trying to migrate from postgres to postgres, It’s possible to remove the

public_

prefix for the table destination?

hiya. unfortunately we do not provide a way of doing this right now. public_ is the schema of the input table. the reason we do this is because if people are importing data from multiple schemas then they have table name collisions.

Understood, Looks like the product is focused on keep sync data between the data warehouse; thank you !

Hey @charles, We are living the same issue. I'm not expert of Java so I couldn't figure out how to remove Public_ prefix. Atleast can you give us a clue how can we remove it for our selves. Thx

What destination are you using? Some destinations will give you an easy way to do this with views.

We are trying to update our local database with Incremental Sync but it changes table name  with public prefix. We just want to sync our local database with production db

Got it. We are actively working on namespacing now https://github.com/airbytehq/airbyte/issues/1921. I'm going to make sure we add your use case to this issue.