↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: Upsert (INSERT ... ON CONFLICT DO ...)

Support for upsert functionality which allows either no action to be taken when a conflict is encountered, or convert the INSERT to an UPDATE.

For more information, please see the INSERT documentation.