PostgreSQL Server Programming (Paperback)

Hannu Krosing, Kirk Roybal, Jim Mlodgenski

  • 出版商: Packt Publishing
  • 出版日期: 2012-06-28
  • 售價: $2,050
  • 貴賓價: 9.5$1,948
  • 語言: 英文
  • 頁數: 264
  • 裝訂: Paperback
  • ISBN: 1849516987
  • ISBN-13: 9781849516983
  • 相關分類: MSSQLPostgreSQLR 語言SQL
  • 海外代購書籍(需單獨結帳)



Take your skills with PostgreSQL to a whole new level with this fascinating guide to server programming. A step by step approach with illuminating examples will educate you in the full range of possibilities.

    Understand the extension framework of PostgreSQL, and leverage it in ways that you haven't even invented yet.

  • Write functions, create your own data types, all in your favourite programming language
  • Step-by-step tutorial with plenty of tips and tricks to kick-start server programming.

In Detail

Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and then extending that right on to the database server. With this knowledge in hand, you will be able to respond to the current demand for advanced PostgreSQL skills in a lucrative and booming market.

"PostgreSQL Server Programming" will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery and a host of other features that the PostgreSQL engine provides.

This book will take you from learning the basic parts of a PostgreSQL function, then writing them in languages other than the built-in PL/PgSQL. You will see how to create libraries of useful code, group them into even more useful components, and distribute them to the community. You will see how to extract data from a multitude of foreign data sources, and then extend PostgreSQL to do it natively. And you can do all of this in a nifty debugging interface that will allow you to do it efficiently and with reliability.

What you will learn from this book

  • Write functions in the built-in PL/PgSQL language or your language of choice
  • Extract data from foreign data sources
  • Add operators, data types, and other custom elements
  • Debug and code efficiently
  • Decide what machine resources your process will use
  • Create your own data types, operators, functions, aggregates, and even your own language
  • Fully integrate the database layer into your development


This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL.

Who this book is written for

"PostgreSQL Server Programming" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice


將您的 PostgreSQL 技能提升到全新的水平,這本引人入勝的伺服器程式設計指南將引導您進入各種可能性。透過逐步的方法和生動的範例,您將全面了解 PostgreSQL 的擴展框架,並以您尚未想到的方式加以利用。


學習如何與 PostgreSQL 一同工作,就像您過去十年一直在使用它一樣。PostgreSQL 能夠為您提供與您喜愛的開發語言相同的選項,並將其擴展到資料庫伺服器。憑藉這些知識,您將能夠滿足當前對高級 PostgreSQL 技能的需求,並在一個有利可圖且蓬勃發展的市場中脫穎而出。

《PostgreSQL Server Programming》將向您展示,PostgreSQL 不僅僅是一個資料庫伺服器,實際上,它甚至可以被視為一個應用程式開發框架,具有事務支持、大量資料儲存、日誌記錄、恢復以及 PostgreSQL 引擎提供的其他一系列功能。

本書將從學習 PostgreSQL 函數的基本部分開始,然後使用內建的 PL/PgSQL 語言以外的語言來撰寫函數。您將了解如何創建有用程式碼的函數庫,將它們組織成更有用的元件,並將它們分發給社群。您將學習如何從多個外部資料來源中提取資料,然後擴展 PostgreSQL 以實現本地支援。而且,您可以在一個方便且可靠的調試介面中高效地進行這些操作。

- 使用內建的 PL/PgSQL 語言或您選擇的語言來撰寫函數
- 從外部資料來源中提取資料
- 添加運算子、資料類型和其他自定義元素
- 進行調試和高效編碼
- 決定您的處理過程將使用的機器資源
- 創建自己的資料類型、運算子、函數、聚合甚至自己的語言
- 將資料庫層完全整合到您的開發中

這本實用指南將引導您深入了解 PostgreSQL 的各個方面。透過逐步範例,您可以輕鬆地設定和擴展 PostgreSQL。

《PostgreSQL Server Programming》適合中高級 PostgreSQL 資料庫專業人士閱讀。為了更好地理解本書,您應該具備撰寫 SQL 的一般經驗、基本的查詢調優概念以及您選擇的一種程式語言的編碼經驗。