> On May 28, 2024, at 1:41 PM, Giovanni Zotta <[email protected]> > wrote: > > AFAIK copy does not have a returning clause, which I need to retrieve the > generated primary key IDs. Is there a way around that? >
Yes. But my way is to assign ids in the client. If you’re using a sequence as Id generator then you have to be able to select the rows back out by input values. Perhaps roll raw data into temp table, join back to that. This assumes there’s a “natural key” in the columns of the raw data. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/FD76DDDD-ECBC-4D04-81CE-C99BFFB5F035%40gmail.com.
