Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZeCRm-0008W2-57 for pgsql-docs@arkaria.postgresql.org; Tue, 22 Sep 2015 01:32:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZeCRl-0003vp-ND for pgsql-docs@arkaria.postgresql.org; Tue, 22 Sep 2015 01:32:41 +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) (envelope-from ) id 1ZeCRQ-0003YF-Rr for pgsql-docs@postgresql.org; Tue, 22 Sep 2015 01:32:21 +0000 Received: from wsip-72-214-29-243.sd.sd.cox.net ([72.214.29.243] helo=joeconway.com) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZeCRO-0000rk-0K for pgsql-docs@postgresql.org; Tue, 22 Sep 2015 01:32:19 +0000 Received: from [192.168.4.41] (account jconway@joeconway.com [192.168.4.41] verified) by joeconway.com (CommuniGate Pro SMTP 6.1.4) with ESMTPSA id 15613474; Mon, 21 Sep 2015 18:32:16 -0700 Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names To: Amir Rohan , "David G. Johnston" References: Cc: "pgsql-docs@postgresql.org" From: Joe Conway X-Enigmail-Draft-Status: N1110 Message-ID: <5600AFA0.8090809@joeconway.com> Date: Mon, 21 Sep 2015 18:32:16 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="MFCQkofMaQp8XH2T695NcwAJDtrf4VX0d" X-Pg-Spam-Score: -0.9 (/) 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 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --MFCQkofMaQp8XH2T695NcwAJDtrf4VX0d Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 09/21/2015 06:04 PM, Amir Rohan wrote: > This belongs in the page describing SELECT, and though I've looked I ha= ven't found it. If I'm wrong ( > I did look again just now), please correct me. Feel free to submit a doc patch if you feel it needs to be improved, but it is mentioned here: http://www.postgresql.org/docs/9.4/interactive/sql-select.html#SQL-FROM 8<----------- alias A substitute name for the FROM item [...] If an alias is written, a column alias list can also be written to provide substitute names for one or more columns of the table. 8<----------- Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --MFCQkofMaQp8XH2T695NcwAJDtrf4VX0d Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBAgAGBQJWAK+gAAoJEDfy90M199hl7c4QAJzx6IqyUGcVe+cneV4GRGAR /PS+7e3Um1xqYIl2xrCLlubm83nmSeHcNfYLWwAd7IEPWybeZT03bFntCtJNmft9 L4lwjEaJoKHBECtPTm528fO5mUR2LtzxySy6mvO/qx/noXyUYQ7rjxLF3JU+35S3 Ifp/gBBIthA9FITRrzfjdHCFoADKjrtipfBBweeSCa/Dki1qE9BEkF38xxLZ0sBo hzo2kcxFBItqgbnYqNSRGULy9Lb6OJCrd7PGoouYyvW0kwQBrCi5dQvS2iIssAh3 UNENZYZF79pL4ZyszcH4IMOARDZx2qqxemKdL9bFoAXxCL8reXMFl+g1++tVtRSZ qE5owFC5HtGtZ2EynfwMsGlf7b1sWv2wzaO5i/Yxl1g9oqnMMbeKE91e+BDgGc3e J4CFeH7br/50ifgZmdxlIk/neTxQ1083hJNU90btT6n2FH3oyOvgLF4jp2JX3BjY pTxIP4fb4Sn8UoerS5TKgdhdHFF6Yao6BODhiQBd7qsgwLn5IId7yZOqnph2curZ P0COiKz8Od5UoLVUcjzkw1DyPwNojXc2GgxfgAcmH5Rhe1ZVS6f1Xjo+2Xf71+7L PwL8mINXv85Z2/bvscwauvBUs+tL21VsvYMD0lyN2aha8aqCFr771reyeiEbhFT1 VY7ONlGLYpVTl6JDnDeA =1AIi -----END PGP SIGNATURE----- --MFCQkofMaQp8XH2T695NcwAJDtrf4VX0d--