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: |