INSERT / UPDATE into 2 inner joined table simultaneously

Lou <[email protected]> Wed, 6 Mar 2019 13:59:22 -0600
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
Hi everyone,

This is my first post here.

I have two tables named c and p. When using SELECT, they are linked
using an INNER JOIN like in this example: "SELECT * FROM c INNER JOIN p
ON c.id = p.c_id WHERE name = 'Jones';"

How can I INSERT new rows into both tables simultaneously with
automatically created id numbers, and how can I UPDATE both tables
simultaneously?

Lou