Re: Can column name aliases be supported? - Mailing list pgsql-general

On 08/22/12 15:19, Gauthier, Dave wrote:
>
> I know a view can be used to alias one of them.

It can alias all of them:

create view xyz as
   select *, last_name as lname, last_name as surname
      from mytable;

(not the nicest version but functional)

HTH.

Bosco.