The following bug has been logged on the website:
Bug reference: 14135
Logged by: Ville Törhönen
Email address: ville@torhonen.fi
PostgreSQL version: 9.5.2
Operating system: CentOS 6.5
Description:
Hello,
On PostgreSQL 9.5.2 SQL commands "analyze" and "analyse" run exactly the
same thing. However, the "analyse" command is completely undocumented.
postgres=# \h analyze
Command: ANALYZE
Description: collect statistics about a database
Syntax:
ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ]
postgres=# \h analyse
No help available for "analyse".
Try \h with no arguments to see available help.
Tab completion does not acknowledge "analyse" command. Product documentation
[1] states that the command "analyse" is reserved, but "Appendix C: SQL Key
Words" is the only page in the whole documentation that mentions the word
"analyse".
Tested with the following PostgreSQL RPM packages from PostgreSQL yum
repository (yum.postgresql.org):
postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64
postgresql95-server-9.5.2-1PGDG.rhel6.x86_64
postgresql95-9.5.2-1PGDG.rhel6.x86_64
postgresql95-contrib-9.5.2-1PGDG.rhel6.x86_64
postgresql95-devel-9.5.2-1PGDG.rhel6.x86_64
Regards,
Ville
[1] http://www.postgresql.org/docs/9.5/static/sql-keywords-appendix.html
