Postgres Pro
Downloads
Home   >   mailing lists

Re: how to get the source table & field name of a view field - Mailing list pgsql-sql

From kkennedy@kenzoid.com (Ken Kennedy)
Subject Re: how to get the source table & field name of a view field
Date
Msg-id 20021107150817.GB32447@abelard.kenzoid.com
Whole thread Raw
In response to how to get the source table & field name of a view field  ("Prime Ho" <ho@optimasoft.com.tw>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: primary keys
Next
From: Richard Huxton
Date:
Subject: Re: PLpgSQL FOR IN EXECUTE question