Hello @francis12 ,
I am still stuck. I have a question: what is the command that is sent when I click on "Create"? Is it CREATE EXTENSION pgvector? If so, wouldn't it be CREATE EXTENSION vector, instead?
EDIT
Solution found. Entered in my Retool db as root (credentials in retooldb.env) and installed pgvector via CREATE EXTENSION vector.