Postgres

Tuned PostgreSQL 10/11/12/13/14/15/16/17 docker image.

• extensions unaccent, intarray
• configured czech language

Discussion / Help

Versions

• PostgreSQL 10/11/12/13/14/15/16/17

Usage

docker run --rm -it -p 5432:5432 dockette/postgres:17
docker run --rm -it -p 5432:5432 dockette/postgres:16
docker run --rm -it -p 5432:5432 dockette/postgres:15
docker run --rm -it -p 5432:5432 dockette/postgres:14
docker run --rm -it -p 5432:5432 dockette/postgres:13
docker run --rm -it -p 5432:5432 dockette/postgres:12
docker run --rm -it -p 5432:5432 dockette/postgres:11
docker run --rm -it -p 5432:5432 dockette/postgres:10

Test

SELECT to_tsvector('czech'::regconfig, 'test'); 
SELECT unaccent('Hôtel'); // Hotel
SELECT unaccent('Žluťoučký kůň'); // Zlutoucky kun

Resources

Thank you for inspiration.

• https://github.com/char0n/postgresql-czech-fulltext
• https://github.com/tjelen/postgres-tsearch-czech
• https://github.com/freaz/docker-postgres-czech-unaccent

Other resources.

• https://postgres.cz/wiki/Instalace_PostgreSQL#Instalace_Fulltextu