cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the all dependent objects on an table in EDB postgres (EPAS 9.6.2.7) ?

Adventurer

How to find the all dependent objects on an table in EDB postgres (EPAS 9.6.2.7) ?

How to find all the dependent objects on table in EPAS 9.6.2.7?

dependent objects includes :-

1. Tables

2. Views

3. Trigger

4. Sequence.

5. Materialized View

6. Stored procedure 

7. Functions

 

Regards,

Sameer Malve

1 REPLY 1
Highlighted
EDB Team Member

Re: How to find the all dependent objects on an table in EDB postgres (EPAS 9.6.2.7) ?

Hi @SameerMalve,

 

In Postgres, the catalog table pg_depend has all the dependency related information of the database objects.

 

You can query this catalog according to your need, below Postgres wiki link has queries to get the dependent objects, you can test them out and modify accordingly.

 

https://wiki.postgresql.org/wiki/Pg_depend_display

 

Regards,
Sudhir