pg_pinyin

pig build pkg pg_pinyin;# build rpm/deb

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

pig install pg_pinyin;# install via package name, for the active PG version  pig install pg_pinyin -v 18; # install for PG 18 pig install pg_pinyin -v 17; # install for PG 17 pig install pg_pinyin -v 16; # install for PG 16 pig install pg_pinyin -v 15; # install for PG 15 pig install pg_pinyin -v 14; # install for PG 14

CREATE EXTENSION pg_pinyin;

CREATE EXTENSION pg_pinyin;

CREATE EXTENSION IF NOT EXISTS pg_pinyin; CREATE EXTENSION IF NOT EXISTS pg_trgm;  CREATE TABLE voice (  id bigserial PRIMARY KEY,  description text NOT NULL,  pinyin text GENERATED ALWAYS AS (public.pinyin_char_romanize(description)) STORED );  CREATE INDEX voice_pinyin_trgm_idx ON voice USING gin (pinyin gin_trgm_ops);  INSERT INTO voice (description) VALUES ('郑爽ABC'); SELECT id, description, pinyin FROM voice;

CREATE TABLE IF NOT EXISTS pinyin.pinyin_mapping_suffix1 (  character text PRIMARY KEY,  pinyin text NOT NULL );  CREATE TABLE IF NOT EXISTS pinyin.pinyin_words_suffix1 (  word text PRIMARY KEY,  pinyin text NOT NULL );  INSERT INTO pinyin.pinyin_mapping_suffix1 (character, pinyin) VALUES ('郑', '|zhengx|') ON CONFLICT (character) DO UPDATE SET pinyin = EXCLUDED.pinyin;  -- Use custom dictionary SELECT public.pinyin_char_romanize('郑爽ABC', '_suffix1');