Is it possible in PostgreSQL to insert field values into a table using multiple selects from various other tables? Something like the following SQL (I have over simplified my original problem). I don't want to perform two individual insert operations.
insert into table_1 (name, id)(select name, id from table_2 limit 1),(select name, id from table_3 limit 1);
أكثر...
insert into table_1 (name, id)(select name, id from table_2 limit 1),(select name, id from table_3 limit 1);
أكثر...