Contents
ALTER FOREIGN TABLE
An SQL command to modify a foreign table
ALTER FOREIGN TABLE
is a DDL command to modify a foreign table
.
ALTER FOREIGN TABLE
was added in PostgreSQL 9.1.
Change history
- PostgreSQL 13
ALTER FOREIGN TABLE ... RENAME COLUMN
returnsALTER FOREIGN TABLE
(instead ofALTER TABLE
) on successful command completion (commit 979766c0)
- PostgreSQL 12
ALTER FOREIGN TABLE ... SET WITH OIDS
syntax removed (commit 578b2297)- support for generated columns via the
GENERATED ALWAYS AS ... STORED
clause added (commit fc22b662)
- PostgreSQL 9.5
ALTER FOREIGN TABLE ... INHERIT / NO INHERIT
syntax added (commit cb1ca4d8)ALTER FOREIGN TABLE ... SET WITH / WITHOUT OIDS
syntax added (commit cb1ca4d8)ALTER FOREIGN TABLE ... ALTER COLUMN ... SET STORAGE
syntax added (commit cb1ca4d8)CURRENT_USER
/SESSION_USER
can now be used to specify user names (commit 31eae602)- support for
CHECK
constraints added (commit fc2ac1fb)
- PostgreSQL 9.4
- support for enabling/disabling triggers added (commit 7cbe57c3)
- PostgreSQL 9.3
ALTER FOREIGN TABLE ... ALTER COLUMN ... SET DEFAULT ... / DROP DEFAULT
syntax added (commit a0c6dfee)
- PostgreSQL 9.2
- PostgreSQL 9.1
- added (commit 0d692a0d)
References
- PostgreSQL documentation: ALTER FOREIGN TABLE