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
