Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f9F28or69081
	for <pgsql-docs@postgreSQL.org>; Sun, 14 Oct 2001 22:08:50 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f9F28lc08855
	for <pgsql-docs@postgreSQL.org>; Sun, 14 Oct 2001 22:08:47 -0400 (EDT)
To: pgsql-docs@postgreSQL.org
Subject: Where to document system views?
Date: Sun, 14 Oct 2001 22:08:47 -0400
Message-ID: <8852.1003111727@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200110/37
X-Sequence-Number: 1051

I have noticed that there is a nearly total lack of documentation of the
various predefined system views, which as of 7.2 include:

	pg_indexes
	pg_rules
	pg_stat_activity
	pg_stat_all_indexes
	pg_stat_all_tables
	pg_stat_database
	pg_stat_sys_indexes
	pg_stat_sys_tables
	pg_stat_user_indexes
	pg_stat_user_tables
	pg_statio_all_indexes
	pg_statio_all_sequences
	pg_statio_all_tables
	pg_statio_sys_indexes
	pg_statio_sys_sequences
	pg_statio_sys_tables
	pg_statio_user_indexes
	pg_statio_user_sequences
	pg_statio_user_tables
	pg_stats
	pg_tables
	pg_user
	pg_views

The lack of docs for the pg_stat* stuff can be blamed on Jan and me,
but the other ones are of longer standing.  My current thought is to
add a section somewhere that describes these views, but where?  I don't
think it's quite right to document them under the System Catalogs
chapter of the Developer's Guide, since they're all intended for use
by ordinary users and dbadmins; the system itself doesn't use them.
Thoughts?

			regards, tom lane