↑↓ select ↵ open ⌫ change scope Open full search

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

Feature: 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.