PostGIS in Action (2nd)
Where the adventure begins

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

1st Edition Chapters    PostGIS In Action 2nd Edition Chapters
Download chapter code and data

  • 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.

Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action