PostgreSQL: Up and Running
PostgreSQL: Up and Running by Regina Obe, published by O’Reilly Media, Inc. in 2012, is a comprehensive guide designed for those considering a migration to PostgreSQL. This edition focuses on the 9.3 release of the open-source database system, highlighting its enterprise-class features and its capabilities as an application platform. The book provides a structured approach to understanding PostgreSQL, making it accessible for both new and existing users.
Readers will find numerous examples that illustrate how to perform tasks that may be challenging in other database systems. The guide covers essential administration tasks such as role management, database creation, and backup procedures. It also delves into advanced topics like LATERAL queries, augmented JSON support, and materialized views. With insights into using the psql command-line utility and the pgAdmin graphical tool, this book serves as a valuable resource for those looking to enhance their skills in SQL and system administration.
Official synopsis Publisher
Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You’ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re an existing PostgreSQL user, you’ll pick up gems you may have missed along the way.Learn basic administration tasks, such as role management, database creation, backup, and restoreApply the psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with Foreign Data WrappersLearn how to replicate data, using built-in replication features
Publisher
Topics
FAQ
What is “PostgreSQL: Up and Running” about?
Who is the author of “PostgreSQL: Up and Running”?
When was “PostgreSQL: Up and Running” published?
What is the ISBN for “PostgreSQL: Up and Running”?
What are the book details (language, pages, edition)?
