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.
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 |