ALTER FOREIGN DATA WRAPPER

A DDL command for modifying the properties of a foreign data wrapper

ALTER FOREIGN DATA WRAPPER is a DDL command for modifying the properties of a foreign data wrapper (FDW).

ALTER FOREIGN DATA WRAPPER was added in PostgreSQL 8.4.

Usage

Normally foreign data wrappers are created by installing the respective extension, and the SQL to create the FDW will be embedded in the extension's SQL file(s). As such, direct modification of the FDW using ALTER FOREIGN DATA WRAPPER is mainly useful for FDW developers.

In practice provision and modification of FDW options is done via CREATE SERVER and ALTER SERVER.

Change history

Categories

DDL, Foreign Data Wrapper (FDW)

See also

CREATE FOREIGN DATA WRAPPER, DROP FOREIGN DATA WRAPPER