aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEtsuro Fujita <efujita@postgresql.org>2022-02-16 15:15:02 +0900
committerEtsuro Fujita <efujita@postgresql.org>2022-02-16 15:15:02 +0900
commita9e186da81d9965789b1a7ab869329eabe3595c3 (patch)
treece0c1cad1e875800bddfc48a472389682cab87e2
parent04645bbcae72c71e5bf28a7a0c96efa851e13ddb (diff)
downloadpostgresql-a9e186da81d9965789b1a7ab869329eabe3595c3.tar.gz
postgresql-a9e186da81d9965789b1a7ab869329eabe3595c3.zip
Doc: Update documentation for modifying postgres_fdw foreign tables.
Document that they can be modified using COPY as well. Back-patch to v11 where commit 3d956d956 added support for COPY in postgres_fdw.
-rw-r--r--doc/src/sgml/postgres-fdw.sgml3
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml
index c1daf127706..9d4d7ccba12 100644
--- a/doc/src/sgml/postgres-fdw.sgml
+++ b/doc/src/sgml/postgres-fdw.sgml
@@ -64,7 +64,8 @@
Now you need only <command>SELECT</command> from a foreign table to access
the data stored in its underlying remote table. You can also modify
the remote table using <command>INSERT</command>, <command>UPDATE</command>,
- <command>DELETE</command>, or <command>TRUNCATE</command>.
+ <command>DELETE</command>, <command>COPY</command>, or
+ <command>TRUNCATE</command>.
(Of course, the remote user you have specified in your user mapping must
have privileges to do these things.)
</para>