is it possible to insert a row with just one call ...
# helpj
Jonas Wells
10/06/2021, 3:50 PMis it possible to insert a row with just one call without the need to use “remote procedure call” when you need to fetch the right foreign key id first ?
I have multiple foreign key so it will mean one additional call for each fk.
s
silentworks
10/06/2021, 4:08 PMIt's not very clear if you are asking about inserting into multiple tables or inserting in one table?
j
Jonas Wells
10/06/2021, 4:09 PMin one table
Jonas Wells
10/06/2021, 4:10 PMbut i need data from another table first
Jonas Wells
10/06/2021, 4:11 PMin psql it will be somethings like that
Jonas Wells
10/06/2021, 4:11 PMINSERT INTO bar (description, foo_id) VALUES
( 'testing', (SELECT id from foo WHERE type='blue') ) );
s
silentworks
10/06/2021, 4:13 PMI don't think this can be done from the supabas-js library without a rpc call
j
Jonas Wells
10/06/2021, 4:14 PMyeah , i will need to learn psql 😄
Jonas Wells
10/06/2021, 4:15 PMthx for the help )