materialised views are not listed in console

[hasura]

materialised views are not listed in console

[0x777]

@eads as a workaround you can create a regular view as follows:

create view somename as select * from materialized_view;

You can now access data from the view somename which in turn fetches data from the materialized view.

[revskill10]

@amesas Could hasura automatically handle Refreshing view for us ?

[mterron]

pg_class probably have what you are looking for:

SELECT n.nspname as "Schema",
  c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'table' END as "Type",
  pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','p','f','v','m')
      AND n.nspname <> 'pg_catalog'
      AND n.nspname <> 'information_schema'
      AND n.nspname !~ '^pg_toast'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;

[eads]

👍 to this PR. Materialized views are a powerful tool for data analysis and it's a bummer I can't access them from Hasura currently.

[revskill10]

Does materialized view automatically get updated when we mutate the related tables ?

[amesas]

Nope by default.

You have to call REFRESH VIEW
https://www.postgresql.org/docs/11/static/sql-refreshmaterializedview.html

We use triggers with REFRESH CONCURRENTLY in some scenarios and a "CRON" in others.

[pyankoff]

@0x777 Thanks for the hack!
Would be great to have a proper solution though

[sfcgeorge]

It's not just showing untracked that doesn't work, even if you create the materialized view within Hasura SQL tab and click "Track" it doesn't show up. So I'll use the view wrapper trick.

[karibertils]

+1 Would love to see this implemented

@0x777 hack is useful until then 😄

[nagautier]

👍 Hack works fine, but it would be cool to have materialized views discovered :).

[pksunkara]

Can we get this before v1?

[ron-johnson]

👍 We would like to see this functionality also

[vitorbertulucci]

It will be really great!!

[poupryc]

Could hasura automatically handle Refreshing view for us ?

It would be absolutely fantastic, I use a cron script for that but centralizing everything in Hasura would be a very good addition for v1.

[thesems]

+1 would be good to have

[garlou]

+1

[GavinRay97]

+1

[bradjabel]

+1

[emailnjv]

+1

[sounden]

+1

[ryanberckmans]

This is fixed in v1.2.2 (or maybe earlier, I upgraded from 1.1)