Postgres:将数据从一个DB的公共模式移动到另一个DB的新模式的最佳方式

I am new to Postgres and just discovered that I cannot access data of different databases in one SQL query. And also learned the concept of schema in Postgres.I am new to Postgres and just discovered that I