pg_summarize

pig build pkg pg_summarize;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_summarize;		# install via package name, for the active PG version

pig install pg_summarize -v 18;   # install for PG 18
pig install pg_summarize -v 17;   # install for PG 17
pig install pg_summarize -v 16;   # install for PG 16
pig install pg_summarize -v 15;   # install for PG 15
pig install pg_summarize -v 14;   # install for PG 14

CREATE EXTENSION pg_summarize;

CREATE EXTENSION pg_summarize;

-- Test the hello function
SELECT hello_pg_summarize();
--  hello_pg_summarize
-- ----------------------
--  Hello, pg_summarize

-- Set the OpenAI API key (required)
ALTER SYSTEM SET pg_summarizer.api_key = 'your_openai_api_key';

-- Optionally set the model (default: gpt-3.5-turbo)
ALTER SYSTEM SET pg_summarizer.model = 'gpt-3.5-turbo';

-- Or set the prompt at session level
SET pg_summarizer.prompt = 'Your custom prompt here';

-- Reload the configuration if set at SYSTEM level
SELECT pg_reload_conf();

-- Summarize a text input
SELECT summarize('<This is the text to be summarized.>');

-- Create a summary table from existing data
CREATE TABLE blogs_summary AS
  SELECT blog_url, summarize(blogs_text)
  FROM hexacluster_blogs;

-- Use a different model
SET pg_summarizer.model = 'gpt-4o';
CREATE TABLE blogs_summary_4o AS
  SELECT blog_url, summarize(blogs_text)
  FROM hexacluster_blogs;