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

symfony - TEST environment only: The database schema is not in sync with the current mapping file -

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -