Re: Documentation - chapter 52, system catalogs

On 04.05.20 17:23, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/catalogs-overview.html
> Description:
>
> The documentation for chapter 52 does not clearly identify the schema
> associated with the system catalogs in either the chapter header or overview
> sections; had I not stumbled across a reference in the documentation for the
> postgres_fdw to the pg_catalog search path, I would have been unable to
> reference the content in those catalogs via foreign data wrappers, and
> although the majority of the content has been exposed via the
> information_schema views and tables, there remain a few elements of interest
> that appear to only exist in the pg_catalog qualified content.

I think that the topic "fdw" is only a symptom, not the real reason for
the confusion. We can improve the chapters "System Catalog" and
"Information Schema" in general by centralizing some already existing
paragraphs in the "Overview" chapter and adding some more explanations.
The attached patch contains:

- for "System Catalog": moving paragraphs from bottom of 51. to top of
51.1. (in PG 11 it is chapter 52); explanation that "System Catalog" is
a synonym for a concrete schema and its tables.

- for "Information Schema": moving paragraphs from bottom of 36. to
middle of 36.1. ; an explanation that it relies on the system catalog;
change the title of 36.1. to "Overview" in correlation with "System
Catalog".

--

Jürgen Purtz