1CREATE TABLE memos (
2  title text,
3  content text
4);
5CREATE INDEX pgrn_index ON memos
6  USING pgroonga (title, content)
7  WITH (normalizers = 'NormalizerNFKC130',
8        normalizers_mapping = '{
9	  "content": "NormalizerNFKC130(\"unify_kana\", true)"
10	}');
11\out null
12SELECT
13  'Lexicon' || 'pgrn_index'::regclass::oid || '_0' as title_lexicon_name,
14  'Lexicon' || 'pgrn_index'::regclass::oid || '_1' as content_lexicon_name;
15\out
16\gset
17SELECT pgroonga_command('schema')::jsonb#>'{1,tables}'
18         ->:'title_lexicon_name'
19         #>'{command,arguments,normalizer}';
20      ?column?
21---------------------
22 "NormalizerNFKC130"
23(1 row)
24
25SELECT pgroonga_command('schema')::jsonb#>'{1,tables}'
26         ->:'content_lexicon_name'
27         #>'{command,arguments,normalizer}';
28                 ?column?
29-------------------------------------------
30 "NormalizerNFKC130(\"unify_kana\", true)"
31(1 row)
32
33DROP TABLE memos;
34