Customize database queries using views in PostgreSQL

March 20, 2006

[From Builder UK]

We show you how to use custom views to improve your productivity in PostgreSQL

One of PostgreSQL's more useful capabilities is the ability to create custom "views". These views are nothing more than pre-defined SQL queries, which are stored in the database and can be re-used as and when needed. Storing frequently-used SQL queries in this manner is more efficient than typing them out each time and also offers greater flexibility, because the data set generated by a view can itself be manipulated using SQL.

This document will show you how to create, use and delete views in PostgreSQL.

The article continues at http://uk.builder.com/architecture/db/0,39026552,39303400,00.htm