ftsIndexes

This configuration option has been deprecated in API version v2.0.0.

This version deprecated the pg_trgm Support Optional feature. Because this configuration option was used for pg_trgm Support, it has been deprecated as well. Until further notice, this configuration option will be used for pg_trgm Support but will not receive any technical support.

Experimental Feature

This configuration entry is related to an Experimental (Optional) feature called pg_trgm Support. Before you start to configure this section, make sure to read the page specific for this feature (accessible here) and this page that explains how to enable Experimental Features.

Type: Map<FileModel, IndexData>

Versioning History

API Version v1.3.0 - Introduced ftsIndexes configuration option.

API Version v2.0.0 - Removed ftsIndexes configuration option.

This object's entries are a key-value pair. When the migrations are generated, Prisma Util will change them to create indexes for these models. To configure your full-text search indexes, add the following line to your exported configuration object:

prisma-util.config.mjs

export default {
    // Other configuration lines
    ftsIndexes: {
        "models/post/Post.prisma": {
            type: "Gin",
            indexes: [{
                language: "english",
                field: "title",
                weight: "A"
            }]
        }
    }
};