Re: cannot EXPLAIN query... - Mailing list pgsql-sql

From Christoph Haller
Subject Re: cannot EXPLAIN query...
Date
Msg-id 3E3E8FB7.E2161FA2@rodos.fzk.de
Whole thread Raw
In response to cannot EXPLAIN query...  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Responses Re: cannot EXPLAIN query...
List pgsql-sql
>
> Sorry Postgresql has really made my VIEWS  ugly.
> It wasnt' so when i fed them.
>
> I wish pgsql stores the create view defination some day ,
> just like it does for indexes (pg_get_indexdef)
>
Did you ever try

SELECT * FROM pg_views ;

It definitely has all view definitions.

Regards, Christoph




pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: cannot EXPLAIN query...
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: cannot EXPLAIN query...