diff options
| -rw-r--r-- | doc/src/sgml/ref/analyze.sgml | 18 | ||||
| -rw-r--r-- | doc/src/sgml/release-12.sgml | 4 | ||||
| -rw-r--r-- | src/bin/psql/tab-complete.c | 2 |
3 files changed, 20 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index fea7f465215..4e70b513b5c 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -26,8 +26,8 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea <phrase>where <replaceable class="parameter">option</replaceable> can be one of:</phrase> - VERBOSE - SKIP_LOCKED + VERBOSE [ <replaceable class="parameter">boolean</replaceable> ] + SKIP_LOCKED [ <replaceable class="parameter">boolean</replaceable> ] <phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase> @@ -96,6 +96,20 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea </varlistentry> <varlistentry> + <term><replaceable class="parameter">boolean</replaceable></term> + <listitem> + <para> + Specifies whether the selected option should be turned on or off. + You can write <literal>TRUE</literal>, <literal>ON</literal>, or + <literal>1</literal> to enable the option, and <literal>FALSE</literal>, + <literal>OFF</literal>, or <literal>0</literal> to disable it. The + <replaceable class="parameter">boolean</replaceable> value can also + be omitted, in which case <literal>TRUE</literal> is assumed. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><replaceable class="parameter">table_name</replaceable></term> <listitem> <para> diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml index d80d89e6a28..90999410db8 100644 --- a/doc/src/sgml/release-12.sgml +++ b/doc/src/sgml/release-12.sgml @@ -1983,8 +1983,8 @@ Author: Robert Haas <rhaas@postgresql.org> --> <para> - Allow <command>VACUUM</command> to take optional boolean argument - specifications (Masahiko Sawada) + Allow <command>VACUUM</command> and <command>ANALYZE</command> + to take optional boolean argument specifications (Masahiko Sawada) </para> </listitem> diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index e4c03de221f..d77aa2936de 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -2101,6 +2101,8 @@ psql_completion(const char *text, int start, int end) */ if (ends_with(prev_wd, '(') || ends_with(prev_wd, ',')) COMPLETE_WITH("VERBOSE", "SKIP_LOCKED"); + else if (TailMatches("VERBOSE|SKIP_LOCKED")) + COMPLETE_WITH("ON", "OFF"); } else if (HeadMatches("ANALYZE") && TailMatches("(")) /* "ANALYZE (" should be caught above, so assume we want columns */ |