ALTER FULLTEXT ... OWNER

Name

ALTER FULLTEXT ... OWNER -- change the owner of a full-text object

Synopsis

ALTER FULLTEXT { PARSER|DICTIONARY|CONFIGURATION } name OWNER TO newowner;
  

Description

ALTER FULLTEXT ... OWNER changes the owner of an existing full-text object.

Parameters

name

The name (optionally schema-qualified) of the full-text object.

newowner

The new owner of the full-text object.

Examples

In this example we want to create new dictionary in schema test using predefined dictionary from system catalog. Then we change owner of the new dictionary. To demonstrate visibility rule we use the name of the dictionary without schema but setting the proper search_path. The name of the new dictionary is the same by intent.

=# CREATE SCHEMA test;
=# CREATE FULLTEXT DICTIONARY test.synonym LIKE pg_catalog."synonym";
=# SHOW search_path;
  search_path
----------------
 "$user",public
=# SET search_path TO test,public;
=# ALTER FULLTEXT DICTIONARY synonym OWNER TO megera;