diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-08-14 22:54:41 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-08-14 22:54:41 -0400 |
| commit | 23d7680d04b958de327be96ffdde8f024140d50e (patch) | |
| tree | 028747dbd292c2b6db01f141f8cc2251c523cc72 /doc/src | |
| parent | d2bc501573d98ff5541271dca94fb5f7a004ecbf (diff) | |
pg_dump: Add a --load-via-partition-root option.
Rushabh Lathia, reviewed and somewhat revised by me. Testing by
Rajkumar Raghuwanshi.
Discussion: http://postgr.es/m/CAGPqQf0C1he087bz9xRBOGZBuESYz9X=Fp8Ca_g+TfHgAff75g@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 15 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 15 |
2 files changed, 30 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index bafa031e1a8..ad5b6fc7035 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -889,6 +889,21 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--load-via-partition-root</></term> + <listitem> + <para> + When dumping a COPY or INSERT statement for a partitioned table, + target the root of the partitioning hierarchy which contains it rather + than the partition itself. This may be useful when reloading data on + a server where rows do not always fall into the same partitions as + they did on the original server. This could happen, for example, if + the partitioning column is of type text and the two system have + different definitions of the collation used to partition the data. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--section=<replaceable class="parameter">sectionname</replaceable></option></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index aa944a2e92a..f8a2521743f 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -431,6 +431,21 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--load-via-partition-root</></term> + <listitem> + <para> + When dumping a COPY or INSERT statement for a partitioned table, + target the root of the partitioning hierarchy which contains it rather + than the partition itself. This may be useful when reloading data on + a server where rows do not always fall into the same partitions as + they did on the original server. This could happen, for example, if + the partitioning column is of type text and the two system have + different definitions of the collation used to partition the data. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--use-set-session-authorization</></term> <listitem> <para> |