Authors: Blum, Richard
Pages: 384
Publisher: Unknow
ISBN13: 9780071485623
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