Hi

Has anyone of you a good pointer to a description of where in the system 
tables I may find what informations? I try to code a generic procedure 
which gets information (like field type, field length, foreign keys...) 
about tables and fields from a system table.

Thank you for your help in advance

sj


Thu, 28 Nov 2002 08:32:46 +0100
Steve Jackson <asdasdfwea@asweweasdv.net>
System Tables
See:

 http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/catalogs.html

for PostgreSQL 7.2.x, for 7.3 see:

 http://developer.postgresql.org/docs/postgres/catalogs.html

Lee.

Steve Jackson writes:
 > Hi
 > 
 > Has anyone of you a good pointer to a description of where in the system 
 > tables I may find what informations? I try to code a generic procedure 
 > which gets information (like field type, field length, foreign keys...) 
 > about tables and fields from a system table.
 > 
 > Thank you for your help in advance

Thu, 28 Nov 2002 18:03:26 +0000
Lee Kindness <lkindness@csl.co.uk>
System Tables
On Thu, 2002-11-28 at 02:32, Steve Jackson wrote:
> Has anyone of you a good pointer to a description of where in the system 
> tables I may find what informations?

The PostgreSQL Developer's Guide has some information:

    http://developer.postgresql.org/docs/postgres/catalogs.html

But IIRC it might be a little out of date. Also, starting psql with "-E"
and taking a look at the queries it uses to generate data is often
useful.

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




28 Nov 2002 13:08:47 -0500
Neil Conway <neilc@samurai.com>
Re: System Tables
On Thursday 28 November 2002 00:32, Steve Jackson wrote:
> Hi
>
> Has anyone of you a good pointer to a description of where in the system
> tables I may find what informations? I try to code a generic procedure
> which gets information (like field type, field length, foreign keys...)
> about tables and fields from a system table.
>

Read the man page for psql.  
Check out the section for PSQL META_COMMANDS.

Sounds like everything you need is in there.

Andy


Thu, 28 Nov 2002 11:17:13 -0700
"Andrew J. Kopciuch" <akopciuch@bddf.ca>
Re: System Tables
Neil Conway <neilc@samurai.com> writes:
>> Has anyone of you a good pointer to a description of where in the system 
>> tables I may find what informations?

> The PostgreSQL Developer's Guide has some information:
>     http://developer.postgresql.org/docs/postgres/catalogs.html

> But IIRC it might be a little out of date.

One would hope not.  It's taken us awhile to finish the work of
documenting every system catalog, but as of 7.3 they are all in there.
I intend to crack the whip as much as necessary to ensure that these
docs get updated whenever someone changes the catalogs ;-)

Actually, pointing people to the developer docs is more likely to create
the reverse problem: what they read there may be too new for the release
they are actually using.

			regards, tom lane

Thu, 28 Nov 2002 17:59:04 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: System Tables 