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
– Severin, Commented Feb 27, 2014 at 12:30
Maybe this could help: stackoverflow.com/questions/4462908/… — Lajos Veres
– Lajos Veres, Commented Feb 27, 2014 at 12:30

Gordon Linoff · Accepted Answer · 2014-02-27 12:30:51Z

5

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, 2014 at 12:30

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL search for a table name in views code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related