create unique index postgres

Kevin answered on July 2, 2022 Popularity 9/10 Helpfulness 5/10

answer create unique index postgres

related PostgreSQL UNIQUE index examples

Comment

CREATE UNIQUE INDEX index_name
ON table_name(column_name, [...]);

Popularity 9/10 Helpfulness 5/10 Language sql

Tags: sql unique-index

Link to this answer
Share Copy Link

Contributed on Jul 02 2022

Kevin

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT 
    tablename, 
    indexname, 
    indexdef 
FROM 
    pg_indexes 
WHERE 
    tablename = 'property_type_language';

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on Sep 08 2022

Worrisome Willet

0 Answers Avg Quality 2/10