- Published on
How to enable pgvector in neon.tech Postgres database
- Ashik Nesin
pgvector is an extension for PostgreSQL using which we can store and query vector data in the database.
It supports indexes and queries using the most popular methods, and works with any PostgreSQL client.
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 IF NOT EXISTS vector;
You can use their SQL Editor to run this query as well :)
Happy playing-with vector!