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