expose a vectorize.base_url to enable the use of other openai API compatible provider

[joshua1]

i am trying to use this (SQL mode) on an application andafter setting up , realised that this only works with openAI API key , but we use Azure Open AI key , which is always invalid because of the endpoint being called to validate it .
Can we please have the option to not just set the key but set an openai compatible endpoint (there are several beyond the one i mentioned )

[ChuckHend]

Hi @joshua1, can you try vectorize.openai_service_url? The default value for this is set to openAI's but can be overriden.

postgres=# show vectorize.openai_service_url ;
 vectorize.openai_service_url 
------------------------------
 https://api.openai.com/v1
(1 row)

postgres=# alter system set vectorize.openai_service_url to 'https://localhost:8080/v1';
ALTER SYSTEM

postgres=# select pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

postgres=# show vectorize.openai_service_url ;
 vectorize.openai_service_url 
------------------------------
 https://localhost:8080/v1
(1 row)