Re: [GENERAL] Views - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [GENERAL] Views
Date
Msg-id 3692C330.42B88AF@krs.ru
Whole thread Raw
Responses Re: [HACKERS] Re: [GENERAL] Views  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] Re: [GENERAL] Views  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
Kaare Rasmussen wrote:
> 
> How can I see a view in psql after having created it? If I enter
> \d <viewname> I can see the fields, but how can I see what makes up the
> view? Best if the original CREATE statement could be listed somehow.

We could use EXPLAIN VIEW for this...
New item for TODO?

EXPLAIN TABLE, EXPLAIN INDEX, etc

Vadim


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] FOR SHARE LOCK clause ?]
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] SQLJ