sqltabs icon indicating copy to clipboard operation
sqltabs copied to clipboard

Materialized views are not include in database info

Open egor-bayandin opened this issue 10 years ago • 2 comments

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: 2015-11-10 17-01-51 sql tabs and what i got using upper select: 2015-11-10 18-06-34 sql tabs

egor-bayandin avatar Nov 10 '15 15:11 egor-bayandin

Yes, MVs are not supported yet, they are in the awaiting list of features.

sasha-alias avatar Nov 11 '15 08:11 sasha-alias

ok, thank you!

egor-bayandin avatar Nov 11 '15 11:11 egor-bayandin