Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Views › Change the SQL Code for a View

Change the SQL Code for a View

Use the SQL tab in the PostgreSQL View Editor to view and change the SQL code that is maintained for a view.

To change the SQL code for a view

1. Right-click the view for which you want to change the SQL code and click Properties.

   The PostgreSQL View Editor opens.

2. Click the SQL tab and click the button.

   The View SQL dialog opens.

3. Add or edit the SQL code as needed. Work with the options on the toolbar to save, print, find and replace, and cut, copy, or paste text.
4. Click Close.

   SQL code is changed for the selected view and the PostgreSQL View Editor closes.