Re: REINDEX VERBOSE DATABASE not working

That looks like a pretty bad syntax to require brackets around a keyword
that has no contextual ambiguity.

On Wed, Jul 3, 2019 at 7:44 PM Fabrízio de Royes Mello <
fabrizio(at)timbira(dot)com(dot)br> wrote:

> Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <
> william(dot)sescu(at)suva(dot)ch> escreveu:
>
>> Hello %
>>
>>
>>
>> Regarding the Docs
>>
>>
>>
>> https://www.postgresql.org/docs/11/sql-reindex.html
>>
>>
>>
>> and due to the REINDEX syntax, I should be able to specify VERBOSE when I
>> run the REINDEX command, to print a progress report.
>>
>>
>>
>> (postgres(at)[local]:55000)[knowledgebase]> \h REINDEX
>>
>> Command: REINDEX
>>
>> Description: rebuild indexes
>>
>> Syntax:
>>
>> REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM }
>> name
>>
>>
>>
>> But it is not working.
>>
>>
>>
>> (postgres(at)[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE
>> knowledgebase;
>>
>> ERROR: syntax error at or near "VERBOSE"
>>
>> LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
>>
>> ^
>>
>>
>>
>> Can somebody help me out regarding this issue.
>>
>>
>>
>
> Your syntax is wrong. Try:
>
> REINDEX (VERBOSE) DATABASE knowledgebase;
>
> Regards
>
> --
> Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>