I dont see any answer to this, I am also facing a problem like this now. I have psql dbs across different servers each db has multiple schemas and I am trying to pipeline the data to a single db for analysis.

If you found solution for this please help.

thanks