Running this query, even as postgres login, displays view_definition only for the views that are created by the current login.
select table_schema as schema_name, table_name as view_name, view_definition
from information_schema.views
where table_schema not in ('information_schema', 'pg_catalog')
order by schema_name, view_name;
Is there some way to get view definition for all views no matter who created them?
If not i plan to just make a job in my etl scheduler to reassign all views to owner postgres.