TIL: Postgres COPY FROM PROGRAM

CREATE TABLE tng (
  title text,
  plot text
);

COPY tng (title, plot)
  FROM PROGRAM 'curl https://raw.githubusercontent.com/pramsey/pgsql-openai/refs/heads/main/examples/rag/tng.txt'
  WITH (
    FORMAT csv,
    DELIMITER E'\t'
);

• PostgreSQL: Documentation: 18: COPY

• via Smarter Postgres LLM with Retrieval Augmented… | Crunchy Data Blog

TIL: Caddy Reverse Proxy GRPC   jazz js