PostgreSQL search for a table name in views code

Question

I have a postgresql database with a lot of schemas, tables and views. Recently, some 3 tables was replaced with one.

Now i have over 1000 views which may use these old tables. Checking them manually is little boring and easy to miss something. Is there any way to search for particular table, or better: schema in all existing views in database?

Your question doesn't make terribly much sense. I'm not even sure what you mean. — Severin, Feb 27 '14 at 12:30
Maybe this could help: http://stackoverflow.com/questions/4462908/find-dependent-objects-for-a-table-or-view — Lajos Veres, Feb 27 '14 at 12:30

score 4 · Accepted Answer · answered Feb 27 '14 at 12:30

4

You can do this through information_schema.views, which is documented here. Something like this:

select v.*
from information_schema.views v
where v.view_definition like '%tablename%';

answered Feb 27 '14 at 12:30

Gordon Linoff

1,242,037
58
646
786

PostgreSQL search for a table name in views code

1 Answers1