I have a Postgres database A with 2 tables, and I need to copy part of these tables (recent records in 1 month) to the new database with the same structures.
How to achieve this, as I know cross database references are not implemented. So I can't select records from the old database to copy to the new one.
I can code, so any ideas are welcome.