sqltabs
sqltabs copied to clipboard
Materialized views are not include in database info
Hi! I found issue, that materialized view is not showing in database info page. Can you fix it pls.
I think it's because information_scheme doesn't contain information about it, but it's possible to get this list using following query:
SELECT oid::regclass::text
FROM pg_class
WHERE relkind = 'm';
Example what i saw now:
and what i got using upper select:

Yes, MVs are not supported yet, they are in the awaiting list of features.
ok, thank you!