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

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] Re: [GENERAL] Views
Date
Msg-id m0zxpoM-000EBRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [GENERAL] Views  (Vadim Mikheev <vadim@krs.ru>)
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
>
>

    SELECT * FROM pg_views;


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-hackers by date:

Previous
From: "Billy G. Allie"
Date:
Subject: Re: Stale porting list?
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [DOCS] Postgresql INSTALL-file & Windows