Bulk Insert RPC to return inserted values.
Hey, Im bulk inserting values in sql using rpc in supabase, is it possible for it to return some column values in the same rpc, like ids and name etc for inserted values
GSure. You can return tables, array of type, or json object of any format in your Postgres function. It will get passed back.
SNo i dont wanna query again, i just want those values which are inserted and their created ids
GYes, just saying you can return values from the same rpc. Are you asking how to get those values in SQL when doing inserts and format them for return? Your question was "is it possible for it to return in the same rpc". And the answer is yes.
Sye both if yes how?? can u like show a basic example
Sim inserting name and age in bulk and i want it to return id, name
Sso how should my function look like
GI would have to write that code and figure out how to build up an array of data to return. I'm just saying it can be done.
googling will probably find ways... Googling
https://dba.stackexchange.com/questions/148876/return-value-directly-from-insert-with-returning-clause
If not you can keep waiting to see if an SQL guru comes along.
googling will probably find ways... Googling
postgres functions returning data from inserts probably would find examples. This one seems to show returning id for a single insert. There is likely one with multiple inserts.https://dba.stackexchange.com/questions/148876/return-value-directly-from-insert-with-returning-clause
If not you can keep waiting to see if an SQL guru comes along.
Database Administrators Stack Exchange
I have a function that ends with:
INSERT INTO configuration_dates (
cols...
) VALUES (
values...
) RETURNING id INTO ret_id;
RETURN ret_id;
And I would like to remove ...
INSERT INTO configuration_dates (
cols...
) VALUES (
values...
) RETURNING id INTO ret_id;
RETURN ret_id;
And I would like to remove ...
Sthere isnt much on multiple entries ill try the code and see if something helps thanks
