Postgresql – Postgres caseinsensitive unique key constraint: What is the fast option?
I want to have a case-insensitive unique key on a large table. I'm looking for the fastest approach. I found two options: my_table_a with a generated column and my_table_b with a unique index CREATE TABLE my_table_a ( my_table_id_a int GENERATED…