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: 8830596.post@talk.nabble.com (view raw or flat)
Thread:
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?
> 
>                http://www.postgresql.org/docs/faq
> 
> 

-- 
View this message in context: http://www.nabble.com/is-there-more-documentation--tf3162955.html#a8830596
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


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-2014 The PostgreSQL Global Development Group