Views

Creating views

Views are created using the CREATE VIEW statement

For example, a common use case is to create a view which queries a table with a pre-defined filter:

Once created, views can be used instead of a table in a statement:

However, it is required, at all times, that the owner (the user who created the view), has privileges on all relations occurring within the view’s query definition.

A common use case for this is to give users access to a subset of a table without exposing the table itself as well. If the owner permissions on the underlying relations, a user who has access to the view will no longer be able to query it.