Handling Multiple Tables with Embeddings in PostgreSQL

[rahul-kbtechnology]

Hello,

I am Rahul, and we are currently facing an issue with our postgres_searcher implementation.

Our requirement is as follows:
We have multiple tables in our database, and we want to integrate all of them for search. In the given example, only the Item table is used, and when a query is asked, the system fetches records only from that single table based on the embeddings.

However, in our case, we have multiple tables such as Cars, Bike, and some relational tables (all of which include embedding columns). What we want is:

When we ask a Cars-related question, the system should fetch data from the Cars table.

When we ask a Bike-related question, the system should fetch data from the Bike table.

When we ask about relational data, the system should fetch from the respective relation table.

We are looking for an example that demonstrates this kind of implementation. Additionally, if there is a better approach to handle such scenarios, we would appreciate your suggestions.

Thanks,
Rahul