Contents
ALTER FOREIGN DATA WRAPPER
An SQL 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
- PostgreSQL 14
ALTER FOREIGN DATA WRAPPER ... OWNER TO CURRENT_ROLE
syntax added (commit 45b98057)
- PostgreSQL 8.4
- added (commit cae565e5)
References
- PostgreSQL documentation: ALTER FOREIGN DATA WRAPPER