Description

In our system, we sometimes use Postgresql views as the table for a Rails model. However, the method PostgresqlAdapter#tables does not support this because it only queries table names.

Right now the method only queries table names:

SELECT tablename FROM pg_tables WHERE schemaname IN (#{schemas})

Its easy to also add in view names like this:

SELECT tablename FROM pg_tables WHERE schemaname IN (#{schemas})

UNION ALL SELECT viewname FROM pg_views WHERE schemaname IN (#{schemas})