System Tables

Started by Robert Kortewegabout 25 years ago3 messagesgeneral
Jump to latest
#1Robert Korteweg
robert@bit.nl

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Robert Korteweg (#1)
Re: System Tables

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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Robert Korteweg (#1)
Re: System Tables

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/