Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA00302; Fri, 25 Jun 1999 09:24:42 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id JAA20591; Fri, 25 Jun 1999 09:23:52 -0400 (EDT) From: Bruce Momjian Message-Id: <199906251323.JAA20591@candle.pha.pa.us> Subject: Re: [DOCS] Doc for pg_* In-Reply-To: <37734C78.D5AAA1C4@bigfoot.de> from Rainer Gottschall at "Jun 25, 1999 11:31:36 am" To: Rainer Gottschall Date: Fri, 25 Jun 1999 09:23:52 -0400 (EDT) CC: pgsql-interfaces@hub.org, pgsql-docs@hub.org X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > I'm currently working on some sort of "PostGres Enterprise Manager" to > give me an easy administration interface for my tables, databases, > functions, etc. To do that I partly analyzed some of the pg_* tables in > the database. I can already get all the information I need right now for > tables, but there are still some small things that I do not know. > So I wondered if there is any documentation of the pg_* tables, except > the ER-diagram in the programming-docs(?). > > Help would be appreciated, > > Rainer > > > Look in contrib/findoidjoins, and run that on an empty database. It will show you the system table joins. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026