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?