Re: which view is used another views

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: which view is used another views
Date: 2011-03-24 17:18:16
Message-ID: 4D8B7CD8.1030501@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
don't know how you go about that.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Altmann, Sebastian 2011-03-24 17:20:38 Re: [RMX:#] Re: Strange loss of data during INSERT
Previous Message Merlin Moncure 2011-03-24 16:57:14 Re: Deadlock in libpq