suse man page for alter_foreign_data_wrapper

Query: alter_foreign_data_wrapper

OS: suse

Section: 7

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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 operation 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 FOREIGN DATA WRAPPER [drop_foreign_data_wrapper(7)] SQL - Language Statements 2010-05-14 ALTER FOREIGN DATA WRAPPER(7)
Related Man Pages
alter_foreign_data_wrapper(7) - centos
alter_server(7) - centos
alter_user_mapping(7) - suse
create_foreign_data_wrapper(7) - suse
create_server(7) - suse
Similar Topics in the Unix Linux Community
egrep not giving desired results
Excluding the records with data only occuring once in first column
Print Selection of Line between two Identifiers.
Convert rows to columns
Text manipulation with sed - Advanced technic