Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Getting last inserted id for each row in postgres

Hi!
This has been discussed many times, but I couldn't find the solution for the exact use case, so any help is appreciated.
So after each row of an insert i'd like to somehow get back the current value of the sequence that was used for the insert, to use in in later tPostgressqlOutput components.
Simplified requirement: Start->Insert User->Insert role for given user
I have done much more complicated things, so I am really stunned why I can't find out the solution myself. For me it is strange that tPostgressqlOutput does not support inserts that return a value.
thanks
eliott
Labels (2)
2 Replies
Anonymous
Not applicable
Author

I've just found a topic that describes a similar requirement and also suggest a solution:
https://community.talend.com/t5/Design-and-Development/handling-ID-generation-and-auto-increament/td...
it this is solved than.
Anonymous
Not applicable
Author

Hi eliott100,
Thanks for your feedback. Could you please mark this post as resolved?
Best regards
Sabrina