wildcard alias

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: wildcard alias
Date: 2006-11-10 22:17:12
Message-ID: 4e289ae65995578a4d160bc20afe5b01@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:

SELECT tablename.* AS alias.*

OR do I have to name each column like:

columnname as alias

Thanks much.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-11-10 22:34:22 Re: wildcard alias
Previous Message Brendan Jurd 2006-11-10 21:56:21 Re: Request for replication advice