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@xxxxxxxxxxxxxx> wrote:
Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <william.sescu@xxxxxxx> 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@[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@[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
