To add records in the main table and child within one transaction?

Question

PostgreSQL

Hello. To add records in the main table and child within one transaction? Thank you.

Answer 1

The question is in the applications that you use.
But, if we talk only about postgresql, then there is an opportunity:
The first option is preferable.
With regards to technical means, all sorts of ORMs can do this automatically.
UPD. Here you can see the general documentation

• https://postgrespro.ru/docs/postgrespro/9.6/sql-insert
  
• https://www.postgresql.org/docs/current/static/sql...