| Lists: | pgsql-docspgsql-interfaces |
|---|
| From: | Rainer Gottschall <rainer(dot)gottschall(at)bigfoot(dot)de> |
|---|---|
| To: | pgsql-interfaces(at)hub(dot)org |
| Cc: | pgsql-docs(at)hub(dot)org |
| Subject: | Doc for pg_* |
| Date: | 1999-06-25 09:31:36 |
| Message-ID: | 37734C78.D5AAA1C4@bigfoot.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-interfaces |
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
| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Rainer Gottschall <rainer(dot)gottschall(at)bigfoot(dot)de> |
| Cc: | pgsql-interfaces(at)hub(dot)org, pgsql-docs(at)hub(dot)org |
| Subject: | Re: [DOCS] Doc for pg_* |
| Date: | 1999-06-25 13:23:52 |
| Message-ID: | 199906251323.JAA20591@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-interfaces |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026