diff options
Diffstat (limited to 'doc/src/sgml/postgres-fdw.sgml')
| -rw-r--r-- | doc/src/sgml/postgres-fdw.sgml | 32 |
1 files changed, 29 insertions, 3 deletions
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index b0792a13b13..fd349569369 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -63,9 +63,10 @@ <para> 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>, or - <command>DELETE</command>. (Of course, the remote user you have specified - in your user mapping must have privileges to do these things.) + the remote table using <command>INSERT</command>, <command>UPDATE</command>, + <command>DELETE</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> <para> @@ -437,6 +438,31 @@ OPTIONS (ADD password_required 'false'); </sect3> <sect3> + <title>Truncatability Options</title> + + <para> + By default all foreign tables using <filename>postgres_fdw</filename> are assumed + to be truncatable. This may be overridden using the following option: + </para> + + <variablelist> + + <varlistentry> + <term><literal>truncatable</literal></term> + <listitem> + <para> + This option controls whether <filename>postgres_fdw</filename> allows + foreign tables to be truncated using <command>TRUNCATE</command> + command. It can be specified for a foreign table or a foreign server. + A table-level option overrides a server-level option. + The default is <literal>true</literal>. + </para> + </listitem> + </varlistentry> + </variablelist> + </sect3> + + <sect3> <title>Importing Options</title> <para> |