Skip to main content

ISBN10: 0071485627 | ISBN13: 9780071485623

PostgreSQL 8 for Windows, 1st Edition

ISBN10: 0071485627
ISBN13: 9780071485623
By Richard Blum

© 2007 Published March 22, 2007

ISBN10: 0071485627 | ISBN13: 9780071485623

More information about this Print book can be found in the page section below.

$61.00
ISBN10: 0071485627 | ISBN13: 9780071485623

More information about this Print book can be found in the page section below.

Step 1. Download Adobe Digital Editions to your PC or Mac desktop/laptop.

Step 2. Register and authorize your Adobe ID (optional). To access your eBook on multiple devices, first create an Adobe ID. Then, open Adobe Digital Editions, go to the Help menu, and select "Authorize Computer" to link your Adobe ID.

Step 3. Open Your eBook. Use Adobe Digital Editions to open the file. If the eBook doesn’t open, contact customer service for assistance.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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

Acknowledgments

Introduction

Part I. Installation and Administration

Chapter 1. Why PostgreSQL?

Chapter 2. Installing PostgreSQL on Windows

Chapter 3. The PostgreSQL Files and Programs

Chapter 4. Managing PostgreSQL on Windows

Part II. Using PostgreSQL in Windows

Chapter 5. The psql Program

Chapter 6. Using Basic SQL

Chapter 7. Using Advanced SQL

Chapter 8. PostgreSQL Functions

Chapter 9. Stored Procedures and Triggers

Chapter 10. Security

Chapter 11: Performance

Part III. Windows Programming with PostgreSQL

Chapter 12. Microsoft Access and PostgreSQL

Chapter 13. Microsoft .NET Framework

Chapter 14. Visual C++

Chapter 14. Java

INDEX

Need support?   We're here to help - Get real-world support and resources every step of the way.

Top