Glossary: PostgreSQL for Developers

upsert

Insert a row, or update the existing one if the insert would break a unique constraint, written with ON CONFLICT.