Re: is there more documentation?

Поиск
Список
Период
Сортировка
От chrisj
Тема Re: is there more documentation?
Дата
Msg-id 8830596.post@talk.nabble.com
обсуждение исходный текст
Ответ на Re: is there more documentation?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Thanks Tom,

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



Tom Lane-2 wrote:
>
> chrisj <chrisj.wood@sympatico.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.


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Jasbinder Singh Bali"
Дата:
Сообщение: Re: Postgre Connection question
Следующее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: Fill multiple fields through one INNER JOIN