On Wed, Jul 20, 2022 at 09:19:17PM -0400, Bruce Momjian wrote: > On Wed, Jul 20, 2022 at 04:32:46PM -0400, Bruce Momjian wrote: > > On Wed, Jul 20, 2022 at 04:23:21PM -0400, Isaac Morland wrote: > > > Will there be a comprehensive list somewhere? Even if it just lists the > > > views, > > > gives maybe a one-sentence description, and links to the relevant > > > chapter, I > > > would find that helpful sometimes. > > > > I was not planning on that since we don't do that in any other cases I > > can think of. > > > > > I ask because I occasionally find myself wanting a comprehensive list of > > > functions, and as far as I can tell it doesn't exist. I'm hoping to avoid > > > that > > > situation for views. > > > > Well, then we just leave them where the are and link to them from other > > parts of the documentation, which I assume/hope we already do. > > People have mentioned the view documentation doesn't belong in the > Internals part. Maybe we can just move it to the Server > Administration part and leave it together.
Thinking some more about this, I wonder if we should distinguish system views that are needed for a task vs those used for reporting. For example, pg_stat_activity is a dymamic view and is needed for monitoring. pg_prepared_statements just reports the prepared statements. Could it be that over time, we have moved the "needed for a task" views into the relevant sections, and the reporting views have just stayed as a group, and that is okay --- maybe they just need to be moved to Server Administration? -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson