Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bLsjM-000506-HC for pgsql-docs@arkaria.postgresql.org; Sat, 09 Jul 2016 13:55:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bLsjM-0007HT-4T for pgsql-docs@arkaria.postgresql.org; Sat, 09 Jul 2016 13:55:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bLsj0-0006tw-NC for pgsql-docs@postgresql.org; Sat, 09 Jul 2016 13:55:18 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bLsit-0004GB-C0 for pgsql-docs@postgresql.org; Sat, 09 Jul 2016 13:55:17 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 1BF952010F; Sat, 9 Jul 2016 09:55:10 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute1.internal (MEProxy); Sat, 09 Jul 2016 09:55:10 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=50T1NO7htFTFEtG J33WaB6teZ2I=; b=NZkKdXCWLj/BXhDmcjtbWecOuoxtkMhNVOMsF+/puBLq8en o9icKLtnAquPkRXtSVPmGrWu0E4PkgX/oUjq3JpFM4FN6X/kIX02eASC1m8BJzIW NYu1cabTM+mGdM+YIoV6FTINcgaGhIu9ut6rgRomZWtYTUf81zaBs0Jz0fbc= X-Sasl-enc: xNRveH3Qm2DNHYAdP6y0Irumwt2MJact5pn7IkjHWAAH 1468072509 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id CFEAFF29F3; Sat, 9 Jul 2016 09:55:09 -0400 (EDT) Subject: Re: Some doc suggestions To: Justin Dearing , pgsql-docs@postgresql.org References: From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <04973fe6-b622-962b-e7cf-0a89a2547500@2ndquadrant.com> Date: Sat, 9 Jul 2016 09:55:09 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On 6/23/16 10:37 PM, Justin Dearing wrote: > Switched jobs recently and returning to postgres after a long hiatus. > The docs are great, but I noticed a few things that could be improved > in the area of catalot documentations. > > 1. The CREATE/ALTER/DROP doc pages should have a link to the > corresponding pg_catalog and INFORMATION_schema tables and views for > that object type. The correspondence between these three is not exactly as cleanly one-to-one as one might think. I think this would be very confusing and not really helpful in practice. > 2. pg_catalog docs should have a link to their corresponding > information_schema table or view and visa versa. same here > 3. Perhaps this page (and its > analogs) https://www.postgresql.org/docs/9.1/static/catalogs.html should > have a 1-3 word description of each catalog. Some are unintuitive. > For example it took awhile to figure out pg_attribute was the list > of columns. That is an automatically generated table of contents. > 4. OID columns should have a note saying something to the effect of "to > get the text name of this simply use atttypid::REGTYPE" We link the OID columns to their corresponding primary key table. We don't have reg* types for everything anyway. > 5. I discovered that pg_catalog.name is a > built in type today, but its not listed as a built in type. I've yet > to find it in the docs. It should either be listed in the built in > types, or the list of built in types should link to the list of > "other built in types" whereever they are. You're right. > If any of those suggestions are ameanable where are the docs for > contributing to the docs? You can send a patch to this list. It's not very different from contributing code. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs