PostgreSQL 8 for Windows

Richard Blum9780071485623, 0071485627

The first book on the first Windows distribution of PostgreSQL This unique resource offers you practical, real-world information on installing, configuring, and using PostgreSQL 8 – the popular open-source database management system – on Windows platforms. Learn how to interface common Windows development platforms, such as Microsoft Access, Microsoft .NET, and Java, with the PostgreSQL database.Richard Blum has been a network and systems administrator for more than 17 years for a large government organization.

---

Table of contents :
PostgreSQL 8 for Windows……Page 1
CONTENTS……Page 7
Introduction……Page 15
1 What Is PostgreSQL?……Page 21
2 Installing PostgreSQL on Windows……Page 43
3 The PostgreSQL Files and Programs……Page 67
4 Managing PostgreSQL on Windows……Page 99
5 The psql Program……Page 139
6 Using Basic SQL……Page 159
7 Using Advanced SQL……Page 187
8 PostgreSQL Functions……Page 213
9 Stored Procedures and Triggers……Page 233
10 Security……Page 253
11 Performance……Page 269
12 Microsoft Access and PostgreSQL……Page 283
13 Microsoft .NET Framework……Page 305
14 Visual C++……Page 331
15 Java……Page 361
Index……Page 385