PostgreSQL

This is the official documentation of PostgreSQL version 11.2. The manual is 2,816 pages long, and has been split into three volumes.The volume ISBN numbers are: Volume One 9781680922738, Volume Two 9781680922745 and Volume Three 9781680922752.Volume One covers chapters Chapters 1-36. Volume Two covers Chapters 37-50 & the Reference section. Volume Three covers Chapters 51-70 & the Appendixes.Each volume as the full Preface, Bibliography and Index sections.This book has been written by the PostgreSQL developers and other volunteers in parallel to the development of the PostgreSQL software. It describes all the functionality that the current version of PostgreSQL officially supports.To make the large amount of information about PostgreSQL manageable in printed form, this book is organized in several parts. Each part is targeted at a different class of users, or at users in different stages of their PostgreSQL experience:• Part I is an informal introduction for new users.• Part II documents the SQL query language environment, including data types and functions, as well as user-level performance tuning. Every PostgreSQL user should read this.• Part III describes the installation and administration of the server. Everyone who runs a PostgreSQL server, be it for private use or for others, should read this part.• Part IV describes the programming interfaces for PostgreSQL client programs.• Part V contains information for advanced users about the extensibility capabilities of the server. Topics include user-defined data types and functions.• Part VI contains reference information about SQL commands, client and server programs. This part supports the other parts with structured information sorted by command or program.• Part VII contains assorted information that might be of use to PostgreSQL developers.You may download the original document as a PDF for free from Postgresql.org.

This book is part of the PostgreSQL 9.0 documentation collection (up-to-date & full), published by Fultus Corporation. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers.

This book is part of the PostgreSQL 9.0 documentation collection (up-to-date & full), published by Fultus Corporation. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers.

Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code.<BR> <BR> PostGIS in Action is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS.<BR> <BR> Register your copy with Manning to get a free ebook and access to the interactive liveBook.