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
Post a Comment