Check if a view is used in PostgreSQL

1.4k views Asked by At

I am having a view in PostgreSQL and i want to check where all places the view is being referenced. I know the below query which will search in all the procedures & functions and will return if it is used.

select * from pg_proc where prosrc ilike '%someview%';

Is there any other way or any alternate solution?

0

There are 0 answers