by
1,287 15
0
3
317
0
Top 10% !
Popular
Specified

Published on:

No tags for this snippet yet.
Languagecsharp
LanguageSQL
SourceGitHub
SourceMyGists

PostgreSQL - full-text search configuration

PostgreSQL - full-text search configuration: 
pg_search_conf_unaccented.sql
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/2582065/PostgreSQL---full-text-search-configurat?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
-- enable extensions -- full-text search on postgresql CREATE EXTENSION unaccent; -- languages supported CREATE TEXT SEARCH CONFIGURATION fr ( COPY = french ); ALTER TEXT SEARCH CONFIGURATION fr ALTER MAPPING FOR hword, hword_part, word WITH unaccent, french_stem; CREATE TEXT SEARCH CONFIGURATION en ( COPY = english ); ALTER TEXT SEARCH CONFIGURATION en ALTER MAPPING FOR hword, hword_part, word WITH unaccent, english_stem; CREATE TEXT SEARCH CONFIGURATION de ( COPY = german ); ALTER TEXT SEARCH CONFIGURATION de ALTER MAPPING FOR hword, hword_part, word WITH unaccent, german_stem; CREATE TEXT SEARCH CONFIGURATION nl ( COPY = dutch ); ALTER TEXT SEARCH CONFIGURATION nl ALTER MAPPING FOR hword, hword_part, word WITH unaccent, dutch_stem; CREATE TEXT SEARCH CONFIGURATION da ( COPY = danish ); ALTER TEXT SEARCH CONFIGURATION da ALTER MAPPING FOR hword, hword_part, word WITH unaccent, danish_stem; CREATE TEXT SEARCH CONFIGURATION fi ( COPY = finnish ); ALTER TEXT SEARCH CONFIGURATION fi ALTER MAPPING FOR hword, hword_part, word WITH unaccent, finnish_stem; CREATE TEXT SEARCH CONFIGURATION hu ( COPY = hungarian ); ALTER TEXT SEARCH CONFIGURATION hu ALTER MAPPING FOR hword, hword_part, word WITH unaccent, hungarian_stem; CREATE TEXT SEARCH CONFIGURATION it ( COPY = italian ); ALTER TEXT SEARCH CONFIGURATION it ALTER MAPPING FOR hword, hword_part, word WITH unaccent, italian_stem; CREATE TEXT SEARCH CONFIGURATION no ( COPY = norwegian ); ALTER TEXT SEARCH CONFIGURATION no ALTER MAPPING FOR hword, hword_part, word WITH unaccent, norwegian_stem; CREATE TEXT SEARCH CONFIGURATION pt ( COPY = portuguese ); ALTER TEXT SEARCH CONFIGURATION pt ALTER MAPPING FOR hword, hword_part, word WITH unaccent, portuguese_stem; CREATE TEXT SEARCH CONFIGURATION ro ( COPY = romanian ); ALTER TEXT SEARCH CONFIGURATION ro ALTER MAPPING FOR hword, hword_part, word WITH unaccent, romanian_stem; CREATE TEXT SEARCH CONFIGURATION ru ( COPY = russian ); ALTER TEXT SEARCH CONFIGURATION ru ALTER MAPPING FOR hword, hword_part, word WITH unaccent, russian_stem; CREATE TEXT SEARCH CONFIGURATION es ( COPY = spanish ); ALTER TEXT SEARCH CONFIGURATION es ALTER MAPPING FOR hword, hword_part, word WITH unaccent, spanish_stem; CREATE TEXT SEARCH CONFIGURATION sv ( COPY = swedish ); ALTER TEXT SEARCH CONFIGURATION sv ALTER MAPPING FOR hword, hword_part, word WITH unaccent, swedish_stem; CREATE TEXT SEARCH CONFIGURATION tr ( COPY = turkish ); ALTER TEXT SEARCH CONFIGURATION tr ALTER MAPPING FOR hword, hword_part, word WITH unaccent, turkish_stem; CREATE TEXT SEARCH CONFIGURATION usimple ( COPY = simple ); ALTER TEXT SEARCH CONFIGURATION usimple ALTER MAPPING FOR hword, hword_part, word WITH unaccent, simple;
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus