How to INSERT INTO a table (not UPDATE) on conflict, generating a new key value?

I have two Postgres tables as shown below, primary key is id:

How to INSERT INTO a table (not UPDATE) on conflict, generating a new key value?

I have two Postgres tables as shown below, primary key is id:

How to INSERT INTO a table (not UPDATE) on conflict, generating a new key value?

I have two Postgres tables as shown below, primary key is id:

How to INSERT INTO a table (not UPDATE) on conflict, generating a new key value?

I have two Postgres tables as shown below, primary key is id: