sasha-alias / sqltabs

Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)
https://www.sqltabs.com
GNU General Public License v3.0
803 stars 57 forks source link

Materialized views are not include in database info #33

Open egor-bayandin opened 8 years ago

egor-bayandin commented 8 years ago

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

sasha-alias commented 8 years ago

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

egor-bayandin commented 8 years ago

ok, thank you!