pg_restore.sgml.diff

text/x-patch

Filename: pg_restore.sgml.diff

Type: text/x-patch

Part: 0

Message: Suggestion for --truncate-tables to pg_restore

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: unified

File	+	−
doc/src/sgml/ref/pg_restore.sgml	20	0

diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml
index b276da6..94d359d 100644
--- a/doc/src/sgml/ref/pg_restore.sgml
+++ b/doc/src/sgml/ref/pg_restore.sgml
@@ -539,6 +539,26 @@
      </varlistentry>
 
      <varlistentry>
+      <term><option>-u</></term>
+      <term><option>--truncate-tables</></term>
+      <listitem>
+       <para>
+        This option is only relevant when performing a data-only
+        restore.  It instructs <application>pg_restore</application>
+        to execute commands to truncate the target tables while the
+        data is reloaded.  Use this when restoring tables or schemas
+        and <option>--clean</clean> cannot be used because dependent
+        objects would be destroyed.
+       </para>
+
+       <para>
+         The <option>--disable-triggers</option> will almost always
+         always need to be used in conjunction with this option to
+         disable check constraints on foreign keys.
+       </para>
+     </varlistentry>
+
+     <varlistentry>
       <term><option>--use-set-session-authorization</option></term>
       <listitem>
        <para>