Top
Enterprise Postgres 17 SP1 Knowledge DataManagement FeatureUser's Guide

3.11.4 Embedded Provider Management Functions

The following functions are provided to set and reference parameters of the embedded provider.

Function

Return type

Description

get_worker_setting(type text, param text)

text

Specify a combination of type and parameter (param) to get the value set for that parameter. Only the user who executed CREATE EXTENSION can execute this command.

set_worker_setting(type text, param text, value text)

void

Specify the combination of type and parameter (param), and set the value (value) for that parameter. Only the user who executed CREATE EXTENSION can execute this command.

The possible embedded provider names and parameters are:

type

param

Description

openai

OPENAI_API_KEY

OpenAI API key value

voyage

VOYAGE_API_KEY

VoyageAI API key value

ollama

OLLAMA_BASE_URL

Ollama API base url

user

VECTORIZE_USER

Username to connect to the database the worker that performs the vectorization.