Online Documentation for SQL Manager for PostgreSQL
A View is a logical table based on one or more tables or views. A view contains no data itself. The tables upon which a view is based are called base tables.
Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table).
View Editor allows you to create new views and define their properties (view name and the SELECT statement it implements). It opens automatically when you create a new view and is available on editing an existing one. SQL Manager supports manual creating and editing of Materialized views.
Hint: A view can be created by building a query in Visual Design Query (click the Create view Navigation bar item after building).
- Using Navigation bar and Toolbar
- Creating/editing view
- Managing columns
- Managing indexes
- Managing rules
- Managing triggers
- Browsing object dependencies
- Working with data
- Editing view description
- Viewing DDL definition
- Setting object permissions