select, columns, and aliases - Mailing list pgsql-general

From CSN
Subject select, columns, and aliases
Date
Msg-id 20040723094801.99656.qmail@web52905.mail.yahoo.com
Whole thread Raw
Responses Re: select, columns, and aliases  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Is it possible to automatically prefix a table alias
(or table name or something else even) to each column
in a select list? For example:

select a.*, b.*
from tablea a
inner tableb b
on a.id=b.aid;

results:

a_id, a_name, b_id, b_name, b_aid


CSN




__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: dumping the schema
Next
From: eClaire
Date:
Subject: phppgadmin and external access