npm

pgroonga

PostgreSQL plugin enabling Groonga full-text search as index

brewmacoslinux

Try with needOr install directly

Source

About

PostgreSQL plugin to use Groonga as index

Commands

pgroonga

Examples

Enable PGroonga extension in PostgreSQL$ psql -d your_database -c 'CREATE EXTENSION pgroonga;'

Create a PGroonga index for full-text search on a text column$ psql -d your_database -c 'CREATE INDEX idx_content ON articles USING pgroonga (content);'

Query using PGroonga full-text search operator$ psql -d your_database -c "SELECT * FROM articles WHERE content @@ 'search_term';"