Prisma•4d ago

gin index

how would I indicate this index exists on my prisma schema...

 CREATE INDEX ON my_table USING gin (my_string_column gin_trgm_ops);

 CREATE INDEX ON my_table USING gin (my_string_column gin_trgm_ops);

2 Replies

FTR, this worked

@@index([my_string_column(ops: raw("gin_trgm_ops"))], type: Gin)

@@index([my_string_column(ops: raw("gin_trgm_ops"))], type: Gin)

Thanks for sharing what worked. The community would find it helpful