- Ashik Nesin
pgvector is an extension for PostgreSQL using which we can store and query vector data in the database.
It supports indexing and querying via the most popular methods and supports any Postgres client as well.
To use vector (embedding) in your database, you'll need to enable it first.
Enable pgvector via SQL
You can run this SQL statement to enable it for your database.
create extension vector;
Enable pgvector via Dashboard
Alternatively, you can enable it via the dashboard as well.
Head over to your Supabase dashboard → Database → Extensions
And enable the Vector extension.
Happy vector data!