EPUB | CHM | PDF

Views

Top Previous Next

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).

You can think of a view as virtual table. It does not physically exist, but works like a real table. Usually it is created by a query joining one or more tables.

With Database Designer for PostgreSQL you can:

§Create it;
§Edit a view;
§Manage all view within the diagram.

See also:
Diagram Objects: Creating a View | View Editor | View Manager