ALTER FOREIGN DATA WRAPPER(7) SQL Commands ALTER FOREIGN DATA WRAPPER(7)NAME
ALTER FOREIGN DATA WRAPPER - change the definition of a foreign-data
wrapper
SYNOPSIS
ALTER FOREIGN DATA WRAPPER name
[ VALIDATOR valfunction | NO VALIDATOR ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ]
ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner
DESCRIPTION
ALTER FOREIGN DATA WRAPPER changes the definition of a foreign-data
wrapper. The first form of the command changes the library or the
generic options of the foreign-data wrapper (at least one clause is
required). The second form changes the owner of the foreign-data wrap‐
per.
Only superusers can alter foreign-data wrappers. Additionally, only
superusers can own foreign-data wrappers.
PARAMETERS
name The name of an existing foreign-data wrapper.
VALIDATOR valfunction
Specifies a new foreign-data wrapper validator function.
Note that it is possible that after changing the validator the
options to the foreign-data wrapper, servers, and user mappings
have become invalid. It is up to the user to make sure that
these options are correct before using the foreign-data wrapper.
NO VALIDATOR
This is used to specify that the foreign-data wrapper should no
longer have a validator function.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the foreign-data wrapper. ADD, SET, and DROP
specify the action to be performed. ADD is assumed if no opera‐
tion is explicitly specified. Option names must be unique; names
and values are also validated using the foreign data wrapper
library.
EXAMPLES
Change a foreign-data wrapper dbi, add option foo, drop bar:
ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar');
Change the foreign-data wrapper dbi validator to bob.myvalidator:
ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator;
COMPATIBILITY
ALTER FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The
standard does not specify the VALIDATOR and OWNER TO variants of the
command.
SEE ALSO
CREATE FOREIGN DATA WRAPPER [create_foreign_data_wrapper(7)], DROP FOR‐
EIGN DATA WRAPPER [drop_foreign_data_wrapper(7)]
SQL - Language Statements 2010-10-01 ALTER FOREIGN DATA WRAPPER(7)
