PostgreSQL as VectorDB - Beginner Tutorial

---
name: postgresql-as-vectordb-beginner-tutorial
version: "1.0.0"
description: "PostgreSQL as a Vector Database (pgvector)"
source: "https://www.youtube.com/watch?v=Ff3tJ4pJEa4"
tags: [DataGrip, pgvector, Pinecone, Weaviate]
---

# PostgreSQL as VectorDB - Beginner Tutorial

> Auto-generated from: PostgreSQL as VectorDB - Beginner Tutorial by Dave Ebbelaar

## Prerequisites
- Python 3.6+
- PostgreSQL with pgvector extension
- Langchain
- psycopg2
- OpenAI API key (if using OpenAI embeddings)

## Quick Start
1. `pip install langchain pgvector psycopg2-binary openai`
2. `CREATE EXTENSION vector; -- Execute this SQL command in your PostgreSQL database`

## What You Get
- Content Type: knowledge
- Difficulty: beginner
- Tools: DataGrip, pgvector, Pinecone, Weaviate