View materialized views

If you have List permission for the object or object class, you can view information about materialized views. Use the nzsql \dm command.

For more information about the \d commands, see Table 1.