Online Documentation for SQL Manager for PostgreSQL

Creating/editing view

Use the View tab of View Editor to create/edit a view and specify its definition.

This tab represents the view definition as SQL statement, hence it is enough to simply edit the whole definition using the editor area to make appropriate changes, and recompile the view.

For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area and Using the context menu.

You can also work on the view definition with the help of the AI Assistant: the context menu of the editor provides the AI Assistant submenu, which lets you have the definition explained, checked, optimized or formatted, or add it to the context of your next request.

Note: The visual representation of a view can be easily created using the Visual Design Query.

Note: You can create Materialized views manually.

To compile a view, you can use the Compile item available within the Navigation bar or toolbar.