Adding schema to PostGresSQL

Rasa Open Source
1

i have been trying to add schema to an existing database, but so far isnt working. Heres my code

tracker_store:
    type: SQL
    dialect: "postgresql"  # the dialect used to interact with the db
    url: "localhost"  # (optional) host of the sql db, e.g. "localhost"
    db: "production"  # path to your db
    username:  "" # username used for authentication
    password:  "" # password used for authentication
    query: # optional dictionary to be added as a query string to the connection URL
      currentSchema: "?currentSchema=chatbot"

im trying to add schema name as “chatbot”, but nothing work

2

@henseljahja update this on endpoint.yml and install posgresql in system or using docker

tracker_store:
       type: SQL
       dialect: "postgresql"  # the dialect used to interact with the db
       url: "localhost"  # (optional) host of the sql db, e.g. "localhost"
       db: "chatbot"  # path to your db
       username: "postgres"  # username used for authentication
       password: "123"  # password used for authentication
       # query: # optional dictionary to be added as a query string to the connection URL
       #   driver: my-driver