Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Mar 21, 2006

Customize database queries using views in PostgreSQL

By DatabaseJournal.com Staff

[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

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM