November 19, 2026: PostgreSQL 19 Released!

Feature Description

ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX

This allows a primary key or unique constraint to be defined using an existing unique index, including a concurrently created unique index.