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 B291352808
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 09:17:26 -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 39445-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Aug 2005 12:17:25 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206])
	by svr1.postgresql.org (Postfix) with ESMTP id 087C45285A
	for <pgsql-sql@postgresql.org>; Thu, 11 Aug 2005 09:17:23 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id i22so357980wra
	for <pgsql-sql@postgresql.org>; Thu, 11 Aug 2005 05:17:27 -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=mfk7ZGOnc8dQoyN+dvbNe89Jf1a4XS1Q1dpPmJkJNwAXTB8vx1FMRWjBOV5lvILXAET9A5huONQpsshEQoW04NQ1awTEHKrQIQQK2YR38Qtsd5dJR+/iWV/oqd2hNcH8UykofVuJ4OX09I9N8Bvd0HNBDYyrcyYgJIlYy0n8yZw=
Received: by 10.54.30.40 with SMTP id d40mr1154487wrd;
	Thu, 11 Aug 2005 05:17:27 -0700 (PDT)
Received: by 10.54.140.12 with HTTP; Thu, 11 Aug 2005 05:17:26 -0700 (PDT)
Message-ID: <17455035050811051779b89949@mail.gmail.com>
Date: Thu, 11 Aug 2005 14:17:26 +0200
From: nori <kodmasin@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to alias table columns in result?
Cc: Mischa Sandberg <mischa.sandberg@telus.net>
In-Reply-To: <20050811095451.B475F252AE9@smtp.nildram.co.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <174550350508110248d4fc071@mail.gmail.com>
	<20050811095451.B475F252AE9@smtp.nildram.co.uk>
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/55
X-Sequence-Number: 22283

Ok I got it. There is no way to alias all columns of some table with
some "prefix" that will be visible in result except to alias each
column.

Tnx Nick, Micsha
P.S. sorry for my bad english

On 8/11/05, Nick Stone <nick@harelane.com> wrote:
> Yes - just alias the columns you need to alias
>=20
> Nick
>