Journal: Software Development

Email: mail@appsoftware.com

Software development notes and articles

A journal for sharing all things software development related


Case insensitive unique constraint

Thu, 12 Sep 2019 14:48 UTC

CREATE UNIQUE INDEX uc_tbl_col on tbl (LOWER("col"));

Ref: http://shuber.io/case-insensitive-unique-constraints-in-postgres/

The information on this site is provided “AS IS” and without warranties of any kind either express or implied. To the fullest extent permissible pursuant to applicable laws, the author disclaims all warranties, express or implied, including, but not limited to, implied warranties of merchantability, non-infringement and suitability for a particular purpose.