> On 02/12/2022 22:55 CET Jonathan Lemig <jtlemig@gmail.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