PostgreSQL 8 for Windows
- 6h 27m
- Richard Blum
- McGraw-Hill/Osborne
- 2007
The easiest way to set up a PostgreSQL database server on Windows
Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database.
- Install and configure PostgreSQL 8 on Windows
- Customize your system using the configuration files
- Work with the utilities
- Administer your database from the pgAdmin III graphical interface
- Use the psql command line program to manually execute SQL commands
- Take advantage of built-in functions or create your own stored procedures and triggers
- Implement tested security measures
- Maintain optimal database performance
- Access a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQL
- Create .NET, Visual C++, and Java applications that interface with your PostgreSQL server
About the Author
Richard Blum has worked for more than 18 years for a large U.S. government organization as a network and systems administrator. During this time he has administered Unix, Linux, Novell, and Microsoft servers and has helped to design and maintain a 3500-user network utilizing Cisco switches and routers.
Rich has a BS in Electrical Engineering and an MS in Management, specializing in Management Information Systems, from Purdue University. He is the author of several books, including sendmail for Linux (Sams Publishing, 2000), Running qmail (Sams Publishing, 2000), Postfix (Sams Publishing, 2001), Open Source E-mail Security (Sams Publishing, 2001), C# Network Programming (Sybex, 2002), Network Performance Open Source Toolkit (John Wiley & Sons, 2003), and Professional Assembly Language Programming (Wrox, 2005).
In this Book
-
Introduction
-
What is PostgreSQL?
-
Installing PostgreSQL on Windows
-
The PostgreSQL Files and Programs
-
Managing PostgreSQL on Windows
-
The psql Program
-
Using Basic SQL
-
Using Advanced SQL
-
PostgreSQL Functions
-
Stored Procedures and Triggers
-
Security
-
Performance
-
Microsoft Access and PostgreSQL
-
Microsoft .NET Framework
-
Visual C++
-
Java
