Get PG search index metadata
get_pg_search_index_metadataRetrieve BM25 index metadata: 13 typed options plus raw index_options. Requires extension installed and existing index.
Instructions
Fetch the parsed reloptions for a single BM25 index (schema.index). Same shape as one entry of list_pg_search_indexes — typed accessors for the 13 documented options plus the raw index_options dict. Raises when the extension is not installed or no BM25 index by that name exists. Returns an object with schema, index, the typed option fields, and index_options (raw reloptions dict for forward-compat).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| index | Yes | ||
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| index | Yes | ||
| table | Yes | ||
| schema | Yes | ||
| columns | Yes | ||
| sort_by | No | ||
| key_field | No | ||
| json_fields | Yes | ||
| layer_sizes | No | ||
| text_fields | Yes | ||
| range_fields | Yes | ||
| index_options | Yes | ||
| boolean_fields | Yes | ||
| numeric_fields | Yes | ||
| datetime_fields | Yes | ||
| search_tokenizer | Yes | ||
| mutable_segment_rows | No | ||
| target_segment_count | No | ||
| background_layer_sizes | No |