How to connect Pinecone to PostgreSQL in the best way?

What would be the best and the most efficient way to connect Pinecone to PostgreSQL? For instance, if I want to save vector embeddings for the text data saved in PostgreSQL in Pinecone and be able to query them there. What would be the most optimal setup for that? Didn’t find any information online or on your website.

One person who claims to work at Pinecone (Greg) said that Pinecone “sits alongside your PostgreSQL warehouse” — would be nice to know how exactly it does it?