psql (15.3, server 15.15) on linux

dvdb=# \d arch_restore
Table "misc.arch_restore"
Column | Type | Collation | Nullable | Default
--------+-------------------+-----------+----------+---------
pk | integer | | not null |
proj | character varying | | |
data | character varying | | |
Indexes:
"archrestorepkey" PRIMARY KEY, btree (pk)

dvdb=# select * from arch_restore order by pk;
pk | proj | data
----+-------+------------
1 | alpha | thedata1
2 | alpha | thedata2
3 | alpha | thedata3
4 | beta | thedata4
5 | beta | thedata5
6 | beta | thedata6
7 | gamma | thedata7
8 | gamma | thedata8
9 | gamma | thedata9
(9 rows)

I decided that it's time to archive the 'beta' project. So I create a new
DB in the PG instance and put them all there leaving...

dvdb=# select * from arch_restore order by pk;
pk | proj | data
----+-------+------------
1 | alpha | thedata1
2 | alpha | thedata2
3 | alpha | thedata3
7 | gamma | thedata7
8 | gamma | thedata8
9 | gamma | thedata9
(9 rows)

And in the "beta_archive" DB I have the beta proj recs...

dvdb=# select * from arch_restore order by pk;
pk | proj | data
----+-------+------------
4 | beta | thedata4
5 | beta | thedata5
6 | beta | thedata6
(9 rows)

The managers tell me that they want to restore "beta" back to the main DB.
I know I could do this with something like a perl script, making
connections to both DBs and transferring them over using select statements
in "beta_archive" and insert statements in the main DB. But is there a
better way, something inherent in PG SQL that allows me to do something
like this ?

SELECT FROM remote (or in this case "remote") PG databases.

The managers tell me that they want to restore "beta" back to the main DB.
I know I could do this with something like a perl script, making
connections to both DBs and transferring them over using select statements
in "beta_archive" and insert statements in the main DB. But is there a
better way, something inherent in PG SQL that allows me to do something
like this ?

psql (15.3, server 15.15) on linux

dvdb=# \d arch_restore

Table "misc.arch_restore"
Column |       Type        | Collation | Nullable | Default
--------+-------------------+-----------+----------+---------
pk     | integer           |           | not null |
proj   | character varying |           |          |
data   | character varying |           |          |
Indexes:
"archrestorepkey" PRIMARY KEY, btree (pk)

dvdb=# select * from arch_restore order by pk;

pk | proj  |    data
----+-------+------------
1 | alpha | thedata1
2 | alpha | thedata2
3 | alpha | thedata3
4 | beta  | thedata4
5 | beta  | thedata5
6 | beta  | thedata6
7 | gamma | thedata7
8 | gamma | thedata8
9 | gamma | thedata9
(9 rows)

I decided that it's time to archive the 'beta' project.  So I create a > new DB in the PG instance and put them all there leaving...

Thanks in Advance