1

Is there any way to know whether a Database column is updated in Postgresql when calling update function in Java in Eclipse? I tried using trigger, but it will only give the number of rows updated. I need to know which column is updated.

4
  • Are you by any chance working with the author of this question, or is it just an amazing, unbelievable coincidence? Commented Aug 3, 2016 at 8:18
  • Yes, We are working together. And sorry for the inconvenience. I haven't noticed him posted the same. Commented Aug 3, 2016 at 9:35
  • Well, like I explained in that comment, there is no ready made mechanism to let you know which column was updated. Plenty of workarounds though, such as first loading the row before performing the update, then comparing. Commented Aug 3, 2016 at 9:43
  • Ok. Thank you so much for your prompt reply Mr.Kayaman Commented Aug 3, 2016 at 12:16

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.