Usage
- https://pgroonga.github.io/
- News: It lists release information.
- Overview: It describes about PGroonga.
- Install: It describes how to install PGroonga.
- Upgrade: It describes how to upgrade PGroonga.
- Uninstall: It describes how to uninstall PGroonga.
- Tutorial: It describes how to use PGroonga step by step.
- FAQ: Frequently asked questions.
- How to: It describes about useful information for specific situations.
- Reference: It describes details for each features such as options, functions and operators.
- Troubleshooting: It describes how to fix troubles.
- Community: It introduces about PGroonga community.
- Users: It lists PGroonga users.
- Development: It describes how to develop PGroonga.
Here’s a quick tutorial about how to use PGroonga:
CREATE EXTENSION IF NOT EXISTS pgroonga;
CREATE TABLE memos
(
id integer,
content text
);
CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);
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 index.');
INSERT INTO memos VALUES (4, 'There is groonga command.');
SET enable_seqscan = off;
-- now let's query pgroonga
SELECT * FROM memos WHERE content &@ 'engine';
-- id | content
-- ----+------------------------------------------------------------------------
-- 2 | Groonga is a fast full text search engine that supports all languages.
-- (1 row)
SELECT * FROM memos WHERE content &@~ 'PGroonga OR PostgreSQL';
-- id | content
-- ----+----------------------------------------------------------------
-- 3 | PGroonga is a PostgreSQL extension that uses Groonga as index.
-- 1 | PostgreSQL is a relational database management system.
-- (2 rows)
SELECT * FROM memos WHERE content LIKE '%engine%';
-- id | content
-- ----+------------------------------------------------------------------------
-- 2 | Groonga is a fast full text search engine that supports all languages.
-- (1 row)