| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-docs(at)postgreSQL(dot)org |
| Subject: | Where to document system views? |
| Date: | 2001-10-15 02:08:47 |
| Message-ID: | 8852.1003111727@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vince Vielhaber | 2001-10-15 13:36:04 | Re: http://www.ca.postgresql.org/docs/tutorial/tutorial.htm |
| Previous Message | Bruce Momjian | 2001-10-12 23:16:59 | Re: pg_hba.conf and Administrator's Guide, 8. Security, User |