Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9C9E4775E4 for ; Thu, 7 Nov 2002 10:32:15 -0500 (EST) Received: from abelard.kenzoid.com (dsl-64-192-97-37.telocity.com [64.192.97.37]) by postgresql.org (Postfix) with ESMTP id 3A36A47719B for ; Thu, 7 Nov 2002 10:08:20 -0500 (EST) Received: by abelard.kenzoid.com (Postfix, from userid 1000) id 99ED42F82; Thu, 7 Nov 2002 10:08:17 -0500 (EST) Date: Thu, 7 Nov 2002 10:08:17 -0500 To: pgsql-sql@postgresql.org Subject: Re: how to get the source table & field name of a view field Message-ID: <20021107150817.GB32447@abelard.kenzoid.com> Reply-To: kenzoid@io.com Mail-Followup-To: pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i From: kkennedy@kenzoid.com (Ken Kennedy) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/108 X-Sequence-Number: 10250 On Thu, Nov 07, 2002 at 05:12:20PM +0800, Prime Ho wrote: > Hi, > > Could you tell me how to get view field's source table and field name? > another word, how could I know the view field come from? > \d view_name should give you the view definition in pqsl. -- Ken Kennedy | http://www.kenzoid.com | kenzoid@io.com