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 EB42A52808 for ; Thu, 11 Aug 2005 09:25:37 -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 13589-01 for ; Thu, 11 Aug 2005 12:25:33 +0000 (GMT) Received: from qtm.net (mummra.qtm.net [216.163.32.14]) by svr1.postgresql.org (Postfix) with SMTP id D107F52869 for ; Thu, 11 Aug 2005 09:25:31 -0300 (ADT) Received: (qmail 32743 invoked from network); 11 Aug 2005 12:25:32 -0000 Received: from unknown (HELO ?192.168.0.110?) (mur@216.163.42.222) by mummra.qtm.net with SMTP; 11 Aug 2005 12:25:32 -0000 Message-ID: <42FB430E.3050703@endpoint.com> Date: Thu, 11 Aug 2005 08:22:38 -0400 From: Jeff Boes Organization: End Point User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: How to alias table columns in result? References: <174550350508110248d4fc071@mail.gmail.com> <20050811095451.B475F252AE9@smtp.nildram.co.uk> <17455035050811051779b89949@mail.gmail.com> In-Reply-To: <17455035050811051779b89949@mail.gmail.com> X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 tagged_above=0 required=5 tests=[AWL=0.061] X-Spam-Level: X-Archive-Number: 200508/56 X-Sequence-Number: 22284 nori wrote: > 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. Only other way would be to write a view for each table, then write all your queries against the views.