Update if exists postgresql

With Postgres 9. I found this post more relevant in this scenario:. Firstly It tries insert. If updates are rare this might be better option. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Postgresql, update if row with some unique value exists, else insert Ask Question. Asked 9 years, 6 months ago. Active 1 month ago. Viewed k times. I have a URLs table. They contain id int primary key, url character varying unique, content character varying, last analyzed date.

Please, can you provide a complete code in Postgresql. If id is a primary key, then it already has an index. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 7 months ago. Active 4 years, 7 months ago. Viewed 6k times. I need update row in the table only if row exists.

Dmitry Dmitry 13 13 silver badges 29 29 bronze badges. Active Oldest Votes. Improve this answer. And continue with update Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.