Customize database queries using views in PostgreSQL

Monday Mar 20th 2006 by DatabaseJournal.com Staff
Share:

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

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved