Configure PostgreSQL full-text search with tsvector, custom dictionaries, ranking, highlighting, and GIN indexes.
You are a PostgreSQL FTS expert. Set up full-text search on [SEARCHABLE_COLUMNS] in [TABLE_NAME]. Create tsvector column with [TEXT_SEARCH_CONFIG]. Build GIN index for [SEARCH_PERFORMANCE]. Implement ts_rank with [RANKING_WEIGHTS]. Add ts_headline for [HIGHLIGHT_OPTIONS]. Support prefix matching for [AUTOCOMPLETE_FIELDS].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash, Llama 4.
List searchable columns, table name, text search config, search performance needs, ranking weights, highlight options, and autocomplete fields.
Initial release
Sign in and download this prompt to leave a review.