September 25, 2025: PostgreSQL 18 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.