How to alias table columns in result? - Mailing list pgsql-sql

From nori
Subject How to alias table columns in result?
Date
Msg-id 1745503505081015455e79f284@mail.gmail.com
Whole thread Raw
Responses Re: How to alias table columns in result?
List pgsql-sql
Hi,

If I have:
1.) table car with columns index and name
2.) table driver with columns index, name and car_index

and query:
SELECT d.*, c.* FROM driver as d LEFT OUTER JOIN car AS c ON
d.car_index=c.index;

How can I get results that have distinct names for columns (ex.
d.name, d.index, c.name, c.index,...)?

tnx
boris


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Breakdown results by month
Next
From: Mischa Sandberg
Date:
Subject: Re: How to alias table columns in result?