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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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