This article lists the steps to follow to help introspect the PostgreSQL DB - Materialized views into TIBCO Data Virtualization (TDV) Studio.

(i) Add the below property in the postgres_<latest_version>.capabilities file, located at [TDV_Install_Dir]apps\dlm\cis_ds_postgresql\conf:
*****
introspect.relational.table_types: TABLE,VIEW,ALIAS,SYNONYM,SYSTEM TABLE,SYSTEM VIEW,SYSTEM INDEX,EXTERNAL TABLE,MATERIALIZED VIEW
*****
(ii). Restart the TDV server and Add/Remove resources on the PostgreSQL data source to check if you see the materialized view or not. 

Since ".capabilities" files are overridden during server upgrades, a more permanent solution would be to add the XML blocks for the above capabilities in the <datasource>_values.xml file. 

Below are the XML block codes that can be added to the [TDV_Install_Dir]/conf/adapters/system/postgres_<version>/postgres_<version>_values.xml file.
Note: Add the below block before the last </common:attributes> tag of the file.
 

<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:name>/custom/introspect.relational.table_types</common:name>
<common:type>STRING</common:type>
<common:value>TABLE,VIEW,ALIAS,SYNONYM,SYSTEM TABLE,SYSTEM VIEW,SYSTEM INDEX,EXTERNAL TABLE,MATERIALIZED VIEW</common:value>
<common:configID>introspect.relational.table_types</common:configID>
</common:attribute>

Restart the TDV server for the changes to take and Add/Remove resources on the PostgreSQL data source to check if you see the materialized view or not.

How to introspect PostgreSQL DB - Materialized views into TIBCO Data Virtualization?