database - Check if a view is used in PostgreSQL -


i having view in postgresql , want check places view being referenced. know below query search in procedures & functions , return if used.

select * pg_proc prosrc ilike '%someview%'; 

is there other way or alternate solution?


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -