Neon Postgres: How To Enable pgvector Extension For RAG Systems (Vector Store)

---
name: neon-postgres-how-to-enable-pgvector-extension-for-rag-syste
version: "1.0.0"
description: "Enable pgvector extension for RAG systems in Neon Postgres"
source: "https://www.youtube.com/watch?v=tF8CdHc0ZnI"
tags: [Neon, PostgreSQL, pgvector]
---

# Neon Postgres: How To Enable pgvector Extension For RAG Systems (Vector Store)

> Auto-generated from: Neon Postgres: How To Enable pgvector Extension For RAG Systems (Vector Store) by Mike Murphy | AI Handyman

## Prerequisites
- A Neon account with a project set up
- psql command-line tool installed and configured

## Quick Start
1. `psql <your_neon_connection_string>`
2. `CREATE EXTENSION IF NOT EXISTS vector;`
3. `SELECT * FROM pg_extension WHERE extname = 'vector';`
4. `CREATE TABLE documents ( id bigserial primary key, context text, embedding vector (1536), metadata jsonb, created_at timestamp default now() );`
5. `CREATE INDEX ON documents USING ivfflat (embedding vector_cosine_ops) WITH (lists = 100);`

## What You Get
- Content Type: knowledge
- Difficulty: intermediate
- Tools: Neon, PostgreSQL, pgvector