Re: how to get the source table & field name of a view field

From: kkennedy(at)kenzoid(dot)com (Ken Kennedy)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to get the source table & field name of a view field
Date: 2002-11-07 15:08:17
Message-ID: 20021107150817.GB32447@abelard.kenzoid.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)io(dot)com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sangeetha Rao 2002-11-07 15:12:59 Re: primary keys
Previous Message Tom Lane 2002-11-07 14:55:29 Re: [SQL] Problem: Referential Integrity Constraints lost