Postgres Pro
Downloads
Home   >   mailing lists

Re: Docs claim that "select myTable.*" wildcard won't let you assign column names - Mailing list pgsql-docs

From Joe Conway
Subject Re: Docs claim that "select myTable.*" wildcard won't let you assign column names
Date
Msg-id 5600AFA0.8090809@joeconway.com
Whole thread Raw
In response to Re: Docs claim that "select myTable.*" wildcard won't let you assign column names  ("Amir Rohan" <amir.rohan@mail.com>)
List pgsql-docs
Tree view 
On 09/21/2015 06:04 PM, Amir Rohan wrote:
> This belongs in the page describing SELECT, and though I've looked I haven'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

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachment

pgsql-docs by date:

Previous
From: "Amir Rohan"
Date:
Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names
Next
From: "David G. Johnston"
Date:
Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names