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	4046	May 6, 2024
Bulk write to table using id's from multiple selected rows in table 💬 Queries and Resources	7	3183	June 18, 2024
Get returning columns (mostly primary key) on bulk upserts with GUI queries 💬 Queries and Resources	4	38	December 21, 2024
Retool Database - Return UUID after Insert 💬 Queries and Resources	5	1747	August 30, 2023
Bulk insert records - Pure SQL statement to get IDs of generated records 💬 Queries and Resources workflows	4	622	June 17, 2024