PostgreSQL 8 for Windows (Database Professional's Library)

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 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 Publisher's 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. PostgreSQL 8 for Windows 1 CONTENTS 7 Introduction 15 1 What Is PostgreSQL? 21 2 Installing PostgreSQL on Windows 43 3 The PostgreSQL Files and Programs 67 4 Managing PostgreSQL on Windows 99 5 The psql Program 139 6 Using Basic SQL 159 7 Using Advanced SQL 187 8 PostgreSQL Functions 213 9 Stored Procedures and Triggers 233 10 Security 253 11 Performance 269 12 Microsoft Access and PostgreSQL 283 13 Microsoft .NET Framework 305 14 Visual C++ 331 15 Java 361 Index 385 Offers you information on installing, configuring, and using PostgreSQL 8, the popular open-source database management system, on Windows platforms. This book helps you learn how to interface common Windows development platforms, such as Microsoft Access, Microsoft .NET, and Java, with the PostgreSQL database. There have been more than 1 million downloads of PostgreSQL 8.1 - two-thirds of these for the Windows platform. This is the first distribution of the software geared toward Windows. There is no other existing documentation for this product