X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8EDE54758C9 for ; Wed, 19 Feb 2003 10:10:38 -0500 (EST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 3C47E475843 for ; Wed, 19 Feb 2003 10:10:37 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Wed Feb 19 16:10:40 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA29932; Wed, 19 Feb 2003 16:10:40 +0100 (MET) Message-ID: <3E539E6F.A4841B91@rodos.fzk.de> Date: Wed, 19 Feb 2003 16:10:40 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: axel@pqrs.de Subject: Re: Default column titles in a select... Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/429 X-Sequence-Number: 11827 > > When doing the following select statement: > select * from a,b where a.objid=b.objid > postgresql returns four columns labeled > objid atext objid atext > instead of what I expected: > a.objid a.atext b.objid b.atext > > With the current result I'm unable to differentiate > between the two 'atext' column. Is there any possibility > to get column headers including the table name in the > result ? > SELECT a.objid AS a_objid, a.atext AS a_atext, b.objid AS b_objid, b.atext AS b_atext FROM a, b WHERE a.objid=b.objid ; Does this help? Probably not really. Regards, Christoph