Thread: Configure StopWords in full text search without a configuration file?
Hello Postgres Community,
is it possible to configure a StopWord list without a file in the configuration-filesystem of postgres? (StopWord: https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-STOPWORDS)
By default, the StopWord files are stored at $SHAREDIR/tsearch_data/*.stop - I don't have access to the filesystem, so I need to configure custom StopWords within my database/schema (SQL-Access).
Is this somehow possible?
Thank you very much,
Regards
Florian
On Thu, 2022-11-17 at 14:30 +0100, Florian Fuchs wrote: > is it possible to configure a StopWord list without a file in the > configuration-filesystem of postgres? > (StopWord: https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-STOPWORDS) No, this is impossible. > By default, the StopWord files are stored at $SHAREDIR/tsearch_data/*.stop - I don't > have access to the filesystem, so I need to configure custom StopWords > within my database/schema (SQL-Access). > > Is this somehow possible? If you have superuser access or have a user that is a member of "pg_write_server_files", you could write the stopword file via SQL. Other than that, I see no possibility. Yours, Laurenz Albe