Microolap Database Designer for PostgreSQL

Creating a View

To create a new view please do the following:

1. Click on the Create View () icon on the Palette toolbar. Your mouse cursor will change its appearance. Click on the diagram area to create a new view. Also you may right-click on some schema in the Tree View object and choose Create View item. A rectangle with the view name will appear on the diagram:

object-view

2. (optional) Double click on the new view symbol in the diagram to call the View Editor. You can set the name of the view and define its SQL query.