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


Reply via email to