Skip to content
Advertisement

How do I update row in postgessql to ignore error?

I am trying to update thousands of rows in my table in postgres but I am getting a user does not exist error, hence my table is not updating. How do I update the rows in table to ignore any errors where a user does not exist in the user table

If for example userid=3 does not exist, how do I ignore any errors and update my rows. Thanks

Advertisement

Answer

I would use values():

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement