Sign in  |  Register
Advanced search
Publication Cover

CITATION

Blum, Richard. PostgreSQL 8 for Windows. US: McGraw-Hill Osborne Media, 2007.

PostgreSQL 8 for Windows

Authors: Richard Blum

Published:  March 2007

eISBN: 9780071509497 0071509496 | ISBN: 9780071485623
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Installation and Administration
  • 1 What Is PostgreSQL?
  • The Open Source Movement
  • The History of PostgreSQL
  • Comparing PostgreSQL
  • PostgreSQL Features
  • Summary
  • 2 Installing PostgreSQL on Windows
  • System Requirements
  • Downloading PostgreSQL
  • Installing PostgreSQL
  • Running PostgreSQL
  • Summary
  • 3 The PostgreSQL Files and Programs
  • The PostgreSQL Directory
  • Database Cluster Directory
  • Configuration Files
  • Programs
  • Summary
  • 4 Managing PostgreSQL on Windows
  • The pgAdmin III Program
  • Parts of the PostgreSQL System
  • Creating a New Application
  • The pgAdmin III Query Tool
  • Working with User Accounts
  • Database Maintenance
  • Backups and Restores
  • Summary
  • Part II: Using PostgreSQL in Windows
  • 5 The psql Program
  • The psql Command-Line Format
  • The psql Meta-commands
  • The psqlrc.conf File
  • Importing Data with psql
  • Summary
  • 6 Using Basic SQL
  • The SQL Query Language
  • Creating Objects
  • Handling Data
  • Querying Data
  • Summary
  • 7 Using Advanced SQL
  • Revisiting the SELECT Command
  • Table Views
  • Table Indexes
  • Transactions
  • Cursors
  • Summary
  • 8 PostgreSQL Functions
  • What Is a Function?
  • String Functions
  • Date and Time Functions
  • Math Functions
  • Aggregate Functions
  • Summary
  • 9 Stored Procedures and Triggers
  • PostgreSQL Procedural Languages
  • Types of Functions
  • The PL/pgSQL Language
  • Triggers
  • Summary
  • 10 Security
  • Controlling Network Users
  • Encrypting Network Sessions
  • Monitoring Users
  • Summary
  • 11 Performance
  • Enhancing Query Performance
  • The postgresql.conf Performance Parameters
  • Summary
  • Part III: Windows Programming with PostgreSQL
  • 12 Microsoft Access and PostgreSQL
  • Interfacing PostgreSQL with Access
  • Creating an Access Application Using PostgreSQL
  • Exporting an Access Application to PostgreSQL
  • Summary
  • 13 Microsoft .NET Framework
  • The Microsoft .NET Framework
  • Creating a .NET Development Environment
  • Integrating the Npgsql Library
  • The Npgsql Library
  • Summary
  • 14 Visual C++
  • The Visual C++ Programming Environment
  • The libpq Library
  • The libpq Functions
  • Summary
  • 15 Java
  • The Java Development Environment
  • PostgreSQL JDBC Driver
  • Java Database Connectivity
  • Summary
  • Index