From 10f55448965f9af3a62070dce840c5c701561630 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 3 Sep 2019 14:25:26 +0200 Subject: Clarify pg_dump documentation Clarify in the help output and documentation that -n, -t etc. take a "pattern" rather than a "schema" or "table" etc. This was especially confusing now that the new pg_dumpall --exclude-database option was documented with "pattern" and the others not, even though they all behave the same. Discussion: https://www.postgresql.org/message-id/flat/b85f3fa1-b350-38d1-1893-4f7911bd7310%402ndquadrant.com --- doc/src/sgml/ref/pg_dump.sgml | 42 +++++++++++++++++++++--------------------- 1 file changed, 21 insertions(+), 21 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 017713f6e45..4bcd4bdaefe 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -375,17 +375,17 @@ PostgreSQL documentation - - + + Dump only schemas matching schema; this selects both the + class="parameter">pattern; this selects both the schema itself, and all its contained objects. When this option is not specified, all non-system schemas in the target database will be dumped. Multiple schemas can be - selected by writing multiple switches. Also, the - schema parameter is + selected by writing multiple switches. The + pattern parameter is interpreted as a pattern according to the same rules used by psql's \d commands (see ), @@ -417,12 +417,12 @@ PostgreSQL documentation - - + + - Do not dump any schemas matching the schema pattern. The pattern is + Do not dump any schemas matching pattern. The pattern is interpreted according to the same rules as for . can be given more than once to exclude schemas matching any of several patterns. @@ -513,16 +513,16 @@ PostgreSQL documentation - - + + Dump only tables with names matching - table. + pattern. For this purpose, table includes views, materialized views, sequences, and foreign tables. Multiple tables - can be selected by writing multiple switches. Also, the - table parameter is + can be selected by writing multiple switches. The + pattern parameter is interpreted as a pattern according to the same rules used by psql's \d commands (see ), @@ -565,12 +565,12 @@ PostgreSQL documentation - - + + - Do not dump any tables matching the table pattern. The pattern is + Do not dump any tables matching pattern. The pattern is interpreted according to the same rules as for . can be given more than once to exclude tables matching any of several patterns. @@ -728,11 +728,11 @@ PostgreSQL documentation - + - Do not dump data for any tables matching the table pattern. The pattern is + Do not dump data for any tables matching pattern. The pattern is interpreted according to the same rules as for . can be given more than once to exclude tables matching any of several patterns. This option is -- cgit v1.2.3