pgvector/init.sql

CREATE EXTENSION IF NOT EXISTS vector;

CREATE TABLE IF NOT EXISTS embeddings (
  id SERIAL PRIMARY KEY,
  embedding vector,
  document text,
  metadata jsonb
  created_at timestamptz DEFAULT now()
);