Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes?

I have 3 postgres databases (up to date with current version) running in AWS that I would like to replicate into one location to build an Operation Data Store (ODS). I require the ability to query cross databases – I’ve primarily only used MSSQL – and I believe that you can only cross query schemas.

Or do I have to put this into another amazon product to be able to achieve this result?