PostgreSQL as Vector Database

Modern retrieval systems are able to more accurately grasp the intentions of users when they make use of semantic search. When doing a semantic search, the context in which terms are used is taken into consideration, as opposed to the more restricted reach of a normal search. This article will explore semantic search as well as the uses that it has in PostgreSQL on an Azure Managed Database.
For the aforementioned, we are utilising the pg_vector extension.
In order to construct a knowledge base and perform query retrieval, we will be utilising hugging-face sentence transformer embedding.
Both Open-AI and Cohere Embeddings are viable options for this purpose.