Setting `default_text_search_config` on a database project


I’m attempting to set the default_text_search_config TO english, as we need this for the to_tsvector function to parse the inputs correctly.

I am using this query:

SET default_text_search_config TO 'english'

However, the value seems to always reset back to simple after the current database connection has been closed. I assume this is down to the “serverless” nature of the platform. Is there any plan on supporting this type of configuration change in the future?

Setting default_text_search_config is now supported. Please try:

ALTER DATABASE dbname SET default_text_search_config = ‘pg_catalog.english’;

SHOW default_text_search_config;