X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 852D352CAF
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 06:48:28 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 56852-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 09:48:26 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 6200052CAA
	for <pgsql-sql@postgresql.org>; Thu, 11 Aug 2005 06:48:25 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id i22so327587wra
	for <pgsql-sql@postgresql.org>; Thu, 11 Aug 2005 02:48:28 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=cNjEEKEPR0pdT/4pJoY0qo9lc+8FUehnen4BODwZPL1K+W5oJEcK2L2XlfWp2HIDM6dAjtJ6NJv7cabYI1KBkZWzOO/J2ljytFw4oKlisinQmm+2kU+hP2DewZRvr1bRlQds5+gPQubpcY23R/dm7sFmZpSzMVvigA9xnsFQhqE=
Received: by 10.54.37.16 with SMTP id k16mr1089760wrk;
	Thu, 11 Aug 2005 02:48:28 -0700 (PDT)
Received: by 10.54.140.12 with HTTP; Thu, 11 Aug 2005 02:48:28 -0700 (PDT)
Message-ID: <174550350508110248d4fc071@mail.gmail.com>
Date: Thu, 11 Aug 2005 11:48:28 +0200
From: nori <kodmasin@gmail.com>
To: Mischa Sandberg <mischa.sandberg@telus.net>
Subject: Re: How to alias table columns in result?
Cc: pgsql-sql@postgresql.org
In-Reply-To: <1123715344.42fa89104f121@webmail.telus.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <1745503505081015455e79f284@mail.gmail.com>
	<1123715344.42fa89104f121@webmail.telus.net>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.024 tagged_above=0 required=5
	tests=[RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200508/53
X-Sequence-Number: 22281

Thanks

Sorry, my question was missing one important detail. My tables have
quite a lot columns (which unfortunately have same names in both
tables) so is it possible to do same as below but without specifying
alias for each column. Now my queries are long and they do not look
nice.

boris

On 8/11/05, Mischa Sandberg <mischa.sandberg@telus.net> wrote:
> SELECT d.name as "d.name",
>        d.index as "d.index",
>        c.name as "c.name",
>        ...