Hello, I’m trying to sync data from PostgreSQL to PostgreSQL. I did not find a way to synchronize only tables in a specific schema.
Hi @ample-dog, can you try specifying the schema in the connection string? It should look like:
kind: source
spec:
name: "postgresql"
registry: "github"
path: "cloudquery/postgresql"
version: "v3.0.6"
tables: ["*"]
spec:
connection_string: "postgresql://postgres:pass@localhost:5432/postgres?search_path=stitch_google_ads"
Yes, it worked, but now I have another problem.
I made the sync in the “public” schema. Where in the destination spec should I change the schema?
The configuration should be similar:
kind: destination
spec:
name: "postgresql"
registry: "github"
path: "cloudquery/postgresql"
version: "v6.1.0"
spec:
connection_string: "postgresql://postgres:pass@localhost:5432/postgres?search_path=stitch_google_ads"
Yep, thanks a lot!
It’s working.
CloudQuery is fantastic!