Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/SHOW_MATERIALIZED_VIEWS.sql

Created July 29, 2021 06:08
Show Gist options
  • Save vvgsrk/e366586059b2e271592eba24b1bbcbf2 to your computer and use it in GitHub Desktop.
Save vvgsrk/e366586059b2e271592eba24b1bbcbf2 to your computer and use it in GitHub Desktop.
Download ZIP
Lists the materialized views that you have privileges to access.
Raw
SHOW_MATERIALIZED_VIEWS.sql
SHOW MATERIALIZED VIEWS LIKE 'INFARE' IN DATABASE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment