Skip site navigation (1) Skip section navigation (2)

Re: is there more documentation?

From: chrisj <chrisj(dot)wood(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: is there more documentation?
Date: 2007-02-06 17:45:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Thanks Tom,

did some experimentation, as you suggested, with some success.

Tom Lane-2 wrote:
> chrisj <chrisj(dot)wood(at)sympatico(dot)ca> writes:
>> However I am now looking for more information on interrogating the
>> catalog
>> and information_schema.  I have about 30 tables and 25 stored procedures
>> (many of my SPs call other SPs), several types and sequences, and still
>> growing.  I would like to determine the dependencies between all these
>> objects but the information_schema does not seem to provide this
>> information.
> AFAIK the information_schema doesn't do that.  You can get such info
> from pg_depend, but there isn't any SQL standard for it.
>> From doing some searches it seems like there may be a whole other world
>> of
>> Postgres documentation I have not stumbled upon.
> Not really, other than the source code and perhaps the techdocs website.
> But feel free to ask questions.  In this case I'd suggest looking at the
> System Catalogs chapter of the manual.  Experimentation helps too.
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

View this message in context:
Sent from the PostgreSQL - novice mailing list archive at

In response to

pgsql-novice by date

Next:From: Andrej Ricnik-BayDate: 2007-02-06 17:46:54
Subject: Re: Fill multiple fields through one INNER JOIN
Previous:From: Jasbinder Singh BaliDate: 2007-02-06 13:08:30
Subject: Re: Postgre Connection question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group