PostgreSQL: Up and Running, 3rd Edition

A Practical Guide to the Advanced Open Source Database



Bookstore > Books > PostgreSQL: Up and Running, 3rd Edition

Price$25.95 - $33.14
Rating
AuthorsRegina Obe, Leo Hsu
PublisherO'Reilly Media
Published2017
Pages314
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101491963417
ISBN-139781491963418
EBook Hardcover Paperback

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system - it's an impressive application platform as well.

With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.

If you're a current PostgreSQL user, you'll pick up gems you may have missed before.

Learn basic administration tasks such as role management, database creation, backup, and restore; Apply the psql command-line utility and the pgAdmin graphical administration tool; Explore PostgreSQL tables, constraints, and indexes; Learn powerful SQL constructs not generally found in other databases; Use several different languages to write database functions; Tune your queries to run as fast as your hardware will allow; Query external and variegated data sources with foreign data wrappers; Learn how to use built-in replication to replicate data.


  1. (2 books)
  2. (2 books)


4 5 204

Similar Books


Twitter API: Up and Running

Twitter API: Up and Running

by Kevin Makice

This groundbreaking book provides you with the skills and resources you need to build web applications for Twitter. Perfect for new and casual programmers intrigued by the microblogging, Twitter API: Up and Running carefully explains how each part of Twitter's API works, with detailed examples that show you how to assemble those buil...

Price:  $25.68  |  Publisher:  O'Reilly Media  |  Release:  2009

Windows 7 Up and Running

Windows 7 Up and Running

by Wei-Meng Lee

This compact book offers the quickest path for Windows XP and Vista users to get started with Microsoft's Windows 7 operating system. With Windows 7: Up and Running, you get the essential information you need to upgrade or install the system and configure it to fit your activities, along with a tour of Windows 7's features and b...

Price:  $15.00  |  Publisher:  O'Reilly Media  |  Release:  2009

Terraform: Up and Running, 3rd Edition

Terraform: Up and Running, 3rd Edition

by Yevgeniy Brikman

Terraform has become a key player in the DevOps world for defining, launching, and managing infrastructure as code (IaC) across a variety of cloud and virtualization platforms, including AWS, Google Cloud, Azure, and more. This hands-on third edition, expanded and thoroughly updated for version 1.0 and beyond, shows you the fastest way to...

Price:  $41.99  |  Publisher:  O'Reilly Media  |  Release:  2022

HTML5: Up and Running

HTML5: Up and Running

by Mark Pilgrim

If you don't know about the new features available in HTML5, now's the time to find out. This book provides practical information about how and why the latest version of this markup language will significantly change the way you develop for the Web.HTML5 is still evolving, yet browsers such as Safari, Mozilla, Opera, and Chrome ...

Price:  $19.39  |  Publisher:  O'Reilly Media  |  Release:  2010

Pro Android Games, 3rd Edition

Pro Android Games, 3rd Edition

by Vladimir Silva, Massimo Nardone

Combining actionable, real-world source code with graphics, Pro Android Games, Third Edition shows you how to build more sophisticated and addictive Android game apps with minimum effort. Harness the power of the latest Android 5.0 SDK to bring countless legendary, action-packed PC games to the Android platform.With actionable real-world ...

Price:  $44.99  |  Publisher:  Apress  |  Release:  2015

Ansible: Up and Running, 3rd Edition

Ansible: Up and Running, 3rd Edition

by Bas Meijer, Lorin Hochstein, Rene Moser

Among the many configuration management tools available, Ansible has some distinct advantages: It's minimal in nature. You don't need to install agents on your nodes. And there's an easy learning curve. With this updated third edition, you'll quickly learn how to be productive with Ansible whether you're a develop...

Price:  $40.00  |  Publisher:  O'Reilly Media  |  Release:  2022

Windows Server 2012: Up and Running

Windows Server 2012: Up and Running

by Samara Lynn

If your organization plans to move to a cloud infrastructure from a LAN or WAN, this book shows you how to do it efficiently with Windows Server 2012. Experienced Windows administrators will learn how to deploy, configure, and manage the server's expanded capabilities and features step-by-step, using clear examples and numerous scree...

Price:  $33.96  |  Publisher:  O'Reilly Media  |  Release:  2012

PostgreSQL: Up and Running, 2nd Edition

PostgreSQL: Up and Running, 2nd Edition

by Regina O. Obe, Leo S. Hsu

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system - it's also an impressive applicatio...

Price:  $25.95  |  Publisher:  O'Reilly Media  |  Release:  2014