, March 25, 2011 6:25:13 PM
Subject: Re: [GENERAL] which view is used another views
On 25 March 2011 19:13, salah jubeh wrote:
Hello Guys
>
>The query in this function returns the dependency for level one. However, I
>need
>the dependency for all level. I am still new with plpgsql s
On 25 March 2011 19:13, salah jubeh wrote:
> Hello Guys
>
> The query in this function returns the dependency for level one. However, I
> need the dependency for all level. I am still new with plpgsql so; how can I
> use recursive function to return all dependency for all levels
>
> CREATE OR REP
__
From: Raymond O'Donnell
To: salah jubeh
Cc: pgsql
Sent: Thu, March 24, 2011 6:18:16 PM
Subject: Re: [GENERAL] which view is used another views
On 24/03/2011 16:06, salah jubeh wrote:
> Hello,
>
> How can I determine the views which are using a certain view.
If you're us
Thanks guys
pg_depend seems Useful, I will check the manual.
Regards
From: Raymond O'Donnell
To: salah jubeh
Cc: pgsql
Sent: Thu, March 24, 2011 6:18:16 PM
Subject: Re: [GENERAL] which view is used another views
On 24/03/2011 16:06, salah jubeh
On 24/03/2011 16:06, salah jubeh wrote:
Hello,
How can I determine the views which are using a certain view.
If you're using pgAdmin, there's a "Dependants" tab which shows you the
objects depending on another object.
Otherwise, I think you can query the pg_catalog.pg_depend table, but I
d
On 24 March 2011 18:06, salah jubeh wrote:
> Hello,
>
> How can I determine the views which are using a certain view.
>
>
Name of the view can be searched on the "view_definition" column of the
"views" view of the information schema.
