Hi! I have a query to perform bulk insert and I'm wondering how to get those data's IDs, so I can use them to create another table. The use case is to build a table along with its bridge table. The problem is that the ID is generated after the record is inserted into the table and I can't access i…

How to get the ID from the bulk inserted records

vangelov September 5, 2022, 1:42pm 7

I wrote a suggestion how to solve this here: Sidestepping Retool's SQL Limitations

Topic		Replies	Views
Bulk insert SQL mode. Is it possible? 💬 Queries and Resources sql , postgres	5	4355	May 6, 2024
Bulk write to table using id's from multiple selected rows in table 💬 Queries and Resources	7	3316	June 18, 2024
Get returning columns (mostly primary key) on bulk upserts with GUI queries 💬 Queries and Resources	4	146	December 21, 2024
Retool Database - Return UUID after Insert 💬 Queries and Resources	5	2118	August 30, 2023
Update and if not exists, insert a row 💬 Queries and Resources	4	285	August 11, 2025