Re: Altnerate Column Return Names

Thomas Swan writes:

> If I do a select * from table1, table2 where table1.id = table2.id I 
> normally get two columns returned with a column identifier of id.

>   id | name | data | id | name | data
> ----+------+------+----+------+------

> Is there anyway to get the result to return
> 
>   table1.id | table1.name | table1.data | table2.id | ,,,
> -----------+-------------+-------------+-----------+- ...

select table1.id as "whatever you want", table1.name as "whatever you
want", table1.data as "something", ...

You get the idea.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden