pgroonga_database

pig build pkg pgroonga;		# build rpm/deb

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

pig install pgroonga;		# install via package name, for the active PG version
pig install pgroonga_database;		# install by extension name, for the current active PG version

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

CREATE EXTENSION pgroonga_database;

CREATE EXTENSION pgroonga_database;
CREATE EXTENSION pgroonga;

-- Create a table with text content
CREATE TABLE memos (
  id integer,
  content text
);

-- Create a PGroonga index
CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);

-- Insert data
INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management system.');
INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that supports all languages.');
INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga as its backend.');

-- Full text search
SELECT * FROM memos WHERE content &@~ 'PostgreSQL OR Groonga';