Sample Header Ad - 728x90

Copy result of a query to a new PostgreSQL database

0 votes
1 answer
101 views
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.
Asked by Tiana987642 (131 rep)
Jun 5, 2019, 11:58 AM
Last activity: Jun 5, 2019, 12:30 PM