-- Reference: http://www.postgresqltutorial.com/postgresql-unique-constraint/
CREATE UNIQUE INDEX services_service_catalog_id
ON services (service_catalog_id);

ALTER TABLE services 
ADD CONSTRAINT unique_service_catalog_id 
UNIQUE USING INDEX services_service_catalog_id;