Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E55E8477062 for ; Thu, 7 Nov 2002 09:26:00 -0500 (EST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 709CB47701B for ; Thu, 7 Nov 2002 09:07:18 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Thu Nov 07 15:06:54 2002 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id PAA06281; Thu, 7 Nov 2002 15:06:53 +0100 (MET) Message-ID: <3DCA737D.BB63C3C3@rodos.fzk.de> Date: Thu, 07 Nov 2002 15:06:53 +0100 From: Christoph Haller X-Mailer: Mozilla 4.06 [en] (X11; I; HP-UX B.10.20 9000/780) MIME-Version: 1.0 To: Prime Ho Cc: pgsql-sql@postgresql.org Subject: Re: how to get the source table & field name of a view field Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/98 X-Sequence-Number: 10240 > 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? Within psql, use \d to learn about the view's column names and types and the view definition. If you were thinking about querying system tables to get this information, start psql with the "-E" option to see how this \d command is implemented. Regards, Christoph