Published on

How to enable pgvector in neon.tech Postgres database

Authors

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 :)

Reference

Happy playing-with vector!