postgreSQL_数据库_计算机类_最新资料_得益网

Beginning Databases with PostgreSQL From Novice to Professional 2nd Edition

2008-03-23 15:14:04

Contents at a Glance
About the Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii
CHAPTER 1 Introduction to PostgreSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
CHAPTER 2 Relational Database Principles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
CHAPTER 3 Getting Started with PostgreSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
CHAPTER 4 Accessing Your Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
CHAPTER 5 PostgreSQL Command-Line and Graphical Tools . . . . . . . . . . . . . . 113
CHAPTER 6 Data Interfacing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
CHAPTER 7 Advanced Data Selection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173
CHAPTER 8 Data Definition and Manipulation . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201
CHAPTER 9 Transactions and Locking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243
CHAPTER 10 Functions, Stored Procedures, and Triggers . . . . . . . . . . . . . . . . . . 267
CHAPTER 11 PostgreSQL Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309
CHAPTER 12 Database Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357
CHAPTER 13 Accessing PostgreSQL from C Using libpq . . . . . . . . . . . . . . . . . . . . 385
CHAPTER 14 Accessing PostgreSQL from C Using Embedded SQL . . . . . . . . . . 419
CHAPTER 15 Accessing PostgreSQL from PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . 445
CHAPTER 16 Accessing PostgreSQL from Perl . . . . . . . . . . . . . . . . . . . . . . . . . . . . 465
CHAPTER 17 Accessing PostgreSQL from Java . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491
CHAPTER 18 Accessing PostgreSQL from C# . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 517
APPENDIX A PostgreSQL Database Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543
APPENDIX B PostgreSQL Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 545
MatthewStones_4789Front.fm Page iii Wednesday, March 9, 2005 9:28 AM
iv ■CONTENTS AT A GLANCE
APPENDIX C PostgreSQL SQL Syntax Reference . . . . . . . . . . . . . . . . . . . . . . . . . . 551
APPENDIX D psql Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 573
APPENDIX E Database Schema and Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577
APPENDIX F Large Objects Support in PostgreSQL . . . . . . . . . . . . . . . . . . . . . . . . 581
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 589

PostgreSQL 8 for Windows

2007-10-30 13:36:27

PostgreSQL 8 for Windows

Author: RICHARD BLUM
Publisher: McGraw-Hill Osborne Media
Number Of Pages: 400
Publication Date: 2007-03-22
Sales Rank: 64036
ISBN / ASIN: 0071485627
EAN: 9780071485623
Binding: Paperback
Manufacturer: McGraw-Hill Osborne Media
Studio: McGraw-Hill Osborne Media
Average Rating: 4

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

对角关系数据库开发

2007-07-24 12:40:18

本书全面介绍了自由的对象关系数据库管理系统 PostgreSOL的安装，配置，管理，使用和开发技巧，能及基于PostgreSOL的Web数据库应用开发技术，ODBC应用开发技术等。最后还给了了PostgreSOL命令，PostgreSOL应用程序及工具的详细参考资料。
本书内容翔实，可操作性强。是一本PostgreSOL使用，管理和开发应用手册，适合软件开发人员和UNIX/LINUX爱好者阅读。对于大专院校计算机软件专业的学生来说，也是一本很好的数据库技术类参考书。

PostgreSQL 8.1 中文文档

2007-03-28 09:55:03

PostgreSQL 是一种特性非常齐全的自由软件的对象-关系性数据库管理系统（ORDBMS），它的很多特性是当今许多商业数据库的前身。
注：本资料来自http://www.pgsqldb.org

PostgreSQL使用手册

2006-08-16 09:52:11

有关PostgreSQL的一切使用方法大全

PostgreSQL Introduction and Concepts

2006-06-30 22:06:11

This book is about POSTGRESQL, the most advanced open source database. From its origins in academia, POSTGRESQL has moved to the Internet with explosive growth. It is hard to believe the advances during the past four years under the guidance of a team of worldwide Internet developers. This book is a testament to their vision, and to the success that POSTGRESQL has become.
The book is designed to lead the reader from their first database query through the complex queries needed to solve real-world problems. No knowledge of database theory or practice is required. However, basic knowledge of operating system capabilities is expected, such as the ability to type at an operating system prompt.

PostgreSQL对象关系数据库开发

2006-06-19 15:27:57

PostgreSQL 8.0.0 中文文档(chm)

2006-06-05 16:24:29

PostgreSQL 8.0.0 中文文档

PostgreSQL 7 数据库开发指南

2006-06-02 14:32:00

PostgreSQL 7 数据库开发指南

postgresql必备参考手册

2006-05-27 21:03:37

postgresql必备参考手册

SQL函数库

2006-05-16 15:34:10

为你在数据库编程中，方便易用的sql函数库！