Документ взят из кэша поисковой машины. Адрес оригинального документа : http://www.sai.msu.su/~megera/postgres/fts/doc/sql-fts-createcfg.html
Дата изменения: Unknown
Дата индексирования: Sun Apr 13 07:52:33 2008
Кодировка:
CREATE FULLTEXT CONFIGURATION

CREATE FULLTEXT CONFIGURATION

Name

CREATE FULLTEXT CONFIGURATION -- create full-text configuration

Synopsis

CREATE FULLTEXT CONFIGURATION cfgname 
PARSER  prsname  [ LOCALE localename] 
[AS DEFAULT];
CREATE FULLTEXT CONFIGURATION cfgname 
[{  PARSER  prsname | LOCALE  localename  }  [ ...]] 
LIKE template_cfg [WITH MAP] 
[AS DEFAULT];

Description

CREATE FULLTEXT CONFIGURATION will create a new FTS configuration. The new configuration will be owned by the user issuing the command.

If a schema name is given (for example, CREATE FULLTEXT CONFIGURATION myschema.cfgname ...) then the configuration is created in the specified schema. Otherwise it is created in the current schema.

Parameters

cfgname

The name (optionally schema-qualified) of the full-text configuration to be created.

PARSER

psrname is the name (optionally schema-qualified) of the parser.

LOCALE

localename is the name of the locale. It should match server's locale (lc_ctype) to identify full-text configuration used by default.

LIKE

Existing full-text configuration template_cfg (optionally schema-qualified) will be used to create new configuration. Values of PARSER, LOCALE parameters, if defined, will substitute default values of the template configuration.

WITH MAP

If specified, then full-text mapping of template configuration is copied to the new configuration.

AS DEFAULT

Set default flag for the configuration, which used to identify if this configuration is selectable on default (see LOCALE description above). It is possible to have maximum one configuration with the same locale and in the same schema with this flag enabled.

Examples

Create new configuration test with default parser and ru_RU.UTF-8 locale.

=# CREATE FULLTEXT CONFIGURATION test  PARSER  default  LOCALE  'ru_RU.UTF-8';
=# \dF+ test
Configuration "public.test"
Parser name: "pg_catalog.default"
Locale: 'ru_RU.UTF-8'
 Token | Dictionaries
-------+--------------

Now we create configuration using english configuration (parser and full-text mapping) but with ru_RU.UTF-8 locale.

=# CREATE FULLTEXT CONFIGURATION test LOCALE  'ru_RU.UTF-8' LIKE english WITH MAP;
CREATE FULLTEXT CONFIGURATION
=# \dF+ test
 Configuration "public.test"
Parser name: "pg_catalog.default"
Locale: 'ru_RU.UTF-8'
    Token     |    Dictionaries
--------------+--------------------
 email        | pg_catalog.simple
 file         | pg_catalog.simple
 float        | pg_catalog.simple
 host         | pg_catalog.simple
 hword        | pg_catalog.simple
 int          | pg_catalog.simple
 lhword       | pg_catalog.en_stem
 lpart_hword  | pg_catalog.en_stem
 lword        | pg_catalog.en_stem
 nlhword      | pg_catalog.simple
 nlpart_hword | pg_catalog.simple
 nlword       | pg_catalog.simple
 part_hword   | pg_catalog.simple
 sfloat       | pg_catalog.simple
 uint         | pg_catalog.simple
 uri          | pg_catalog.simple
 url          | pg_catalog.simple
 version      | pg_catalog.simple
 word         | pg_catalog.simple

In the example below we first create test configuration (in public schema by default) with default flag enabled using system configuration pg_catalog.russian_utf8 as template. Then, we create another configuration with the same parameters as earlier and show that default flag was removed from test configuration.

=# CREATE FULLTEXT CONFIGURATION test LIKE pg_catalog.russian_utf8 AS DEFAULT;
CREATE FULLTEXT CONFIGURATION
=# \dF public.test
           List of fulltext configurations
 Schema | Name |   Locale    | Default | Description
--------+------+-------------+---------+-------------
 public | test | ru_RU.UTF-8 | Y       |
=# CREATE FULLTEXT CONFIGURATION test2 LIKE pg_catalog.russian_utf8 AS DEFAULT;
NOTICE:  drop default flag for fulltext configuration "public.test"
=# \dF public.test*        
	   List of fulltext configurations
 Schema | Name  |   Locale    | Default | Description
--------+-------+-------------+---------+-------------
 public | test  | ru_RU.UTF-8 |         |
 public | test2 | ru_RU.UTF-8 | Y       |
=# ALTER FULLTEXT CONFIGURATION test2 DROP DEFAULT;
ALTER FULLTEXT CONFIGURATION
=# \dF public.test*
           List of fulltext configurations
 Schema | Name  |   Locale    | Default | Description
--------+-------+-------------+---------+-------------
 public | test  | ru_RU.UTF-8 |         |
 public | test2 | ru_RU.UTF-8 |         |

See Also

DROP FULLTEXT CONFIGURATION, ALTER FULLTEXT CONFIGURATION