highlighting the search term FTS PostgreSQL

[amrutadotorg]

Hi, is there a way to highlight the words using FTS in PostgreSQL?

thank you

SELECT 
    'text' AS component;

SELECT post.id, 
       ts_headline('english', post.content, plainto_tsquery('english', $search), 'StartSel=<mark>, StopSel=</mark>') AS contents,
       translations.language_code
FROM post
JOIN translations ON translations.element_id = post.id
  AND translations.element_type = 'post_post'
  AND translations.language_code = 'en'
WHERE post.content_tsv @@ plainto_tsquery('english', $search);

[lovasoa]

You can use the StartSel and StopSel options of the ts_headline function to make postgres return search results highlighted in markdown, and then use the description_md row-level parameter to display the resulting markdown text.

https://www.postgresql.org/docs/current/textsearch-controls.html

[amrutadotorg]

Thank you. I think I was not precise enough. I would like to use a color for highlighting.

[lovasoa]

That is not possible with the built-in components, but you have two possibilities:

• can create your own component, specific to your application that will display raw html :/https://sql.ophir.dev/custom_components.sql
• add a custom css stylesheet from the shell component to style bold text the Way you need inside results, and use markdown to display search terms as bold text

[amrutadotorg]

Thank you for the ideas.