White Papers

Customize database queries and their presentation using views in PostgreSQL

Overview One of PostgreSQL's more useful capabilities is the ability to create custom views. This document will show you how to create, use and delete views.

Customizing the way data is retrieved from a database and then displayed is a vital to the conveyance of useful information to decision makers. This customization is accomplished in PostgreSQL by creating pre-defined SQL queries, which are stored in the database and can be re-used as and when needed. This download walks you through the necessary queries and commands to show you how to create, use, store and delete these pre-defined views.

Are you ever really happy with the performance of your queries or are you merely content that it's the best you can do? Is there another aspect of PostgreSQL you would like to see covered in a TechRepublic download?

This download is also available as a TechRepublic article.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: TechRepublic
File Format: Other Download
Date Published: May 25, 2006
Format: White Papers
Topics: Database Management

Similiar White Papers

BPM Done Right: 15 Ways To Succeed Where Others Have Failed

Business Process Management (BPM) promises are real, but the path to success is littered with pitfalls and shortcuts to

Publisher: Software AG

SQL Server 2000 Enterprise Edition (64-bit): Advantages of a 64-Bit Environment

HP has partnered with Microsoft to provide information about the advantages of a 64-Bit Environment. Microsoft SQL Serv

Publisher: Hewlett-Packard | Tags: applications, software

The ROI of Data Governance - A Revenue Generation Perspective

"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). T

Publisher: DataFlux | Tags: data, metadata

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

For many years, large enterprises have relied on Fibre Channel (FCP) as the default Storage Area Network (SAN) protocol

Publisher: Network Appliance (NetApp) | Tags: database, ethernet, ip, tco

Quickly import data into Excel with these techniques

This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applica

Publisher: TechRepublic | Tags: applications, data, excel

TechRepublic White Papers

Build your own consulting contract using this sample form

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »