PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #1) Appendix D - PostgreSQL Features

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st Edition Chapters
  • Useful PostgreSQL resources
  • Connecting to PostgreSQL Server
  • Controlling access to data
  • Backup and Restore
  • Data Structures and PostgreSQL Objects
  • Writing PostgreSQL Stored functions, triggers and rules in PL/PgSQL and SQL.

This chapter highlights the key features of PostgreSQL. We start with an anatomy of PostgreSQL. We then discuss how to do some common tasks in PostgreSQL you would need to know of any relational database you work with.

Sample PL/PgSQL, SQL functions are demonstrated and some examples of using triggers, using rules to implement updateable views, and writing aggregate functions.

Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,3rd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook 2nd edition