Re: Views "missing" from information_schema.view_table_usage

> On 02/12/2022 22:55 CET Jonathan Lemig <jtlemig(at)gmail(dot)com> wrote:
>
> drps=> select viewowner, schemaname, viewname from pg_views where viewname = 'platform_version_v';
>  viewowner | schemaname | viewname
> -----------+------------+--------------------
>  drps | event | platform_version_v
> (1 row)
>
> drps=> select * from information_schema.view_table_usage where view_name = 'platform_version_v';
>  view_catalog | view_schema | view_name | table_catalog | table_schema | table_name
> --------------+-------------+-----------+---------------+--------------+------------
> (0 rows)
>
> The event.platform_version_v doesn't show up when querying the view_table_usage view.

Does platform_version_v reference any tables? That view name suggests that it
provides some version info, e.g. with a definition like:

create view event.platform_version_v as select '1.0.0' as version;

In that case it won't appear in view_table_usage.

--
Erik