Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Materialized Views › Define User Defined SQL for a Materialized View

Define User Defined SQL for a Materialized View

The User Defined SQL tab is identical for the physical property editors that use it. Use the User Defined SQL tab to view and change a user-provided DDL statement. The following options are available for this tab:

User-Defined SQL

Select the check box to change the SQL code in the SQL Statement box. Select this check box only if you want the object to contain syntax that erwin Data Modeler cannot represent, for example, a UNION statement. When you select this check box, you no longer maintain references to the base tables and columns to which the object refers.