Thread: System Tables

System Tables

From
Robert Korteweg
Date:
Hi,

I made a list of all the system tables and there columns in an ascii
file. the only thing i am still missing is the meening of the columns :(

Q: does anyone already have such a file with explanations to each
column?
Q: does anyone know if there is a more accurate overview than the one on
the website (it is missing a lot of columns)?

thanks in advance
Robert Korteweg
The Netherlands

Re: System Tables

From
Peter Eisentraut
Date:
Robert Korteweg writes:

> I made a list of all the system tables and there columns in an ascii
> file. the only thing i am still missing is the meening of the columns :(
>
> Q: does anyone already have such a file with explanations to each
> column?
> Q: does anyone know if there is a more accurate overview than the one on
> the website (it is missing a lot of columns)?

Maybe you haven't seen this::

http://www.postgresql.org/devel-corner/docs/postgres/catalogs.html

If you're talking about the graph, you're right, that's pretty scarce.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Re: System Tables

From
Tom Lane
Date:
Robert Korteweg <robert@bit.nl> writes:
> I made a list of all the system tables and there columns in an ascii
> file. the only thing i am still missing is the meening of the columns :(

> Q: does anyone already have such a file with explanations to each
> column?

Read the source code ... specifically the table declarations in
src/include/catalog/

            regards, tom lane