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 application platform. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. 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 features to replicate data
Obe, Regina O./ Hsu, Leo S.
Most Helpful Customer Reviews
So, first of all I'm a PostgreSQL user for 7 years and an instructor for 3 years. I feel that PostgreSQL has one of the absolute best online documentation repos of any open source project. Easy to use and find answers.
However, in teaching PostgreSQL administration, I find that there are still quite a few individuals who like a comprehensive introduction to a topic. Quite a few of these individuals like that comprehensive introduction to be in book form. This is a good resource for those individuals.
WHAT I LIKE: 1) The authors are active in using PostgreSQL
It is obvious from the tone in which the book is written. Small things, like knowing that Amazon's Redshift is a fork of a PostgreSQL fork . . . aren't monumental, but give the authors credibility in my mind since I use Postgres in its community, EnterpriseDB, and Redshift flavors.
2) Concise, quick tips for administrators
There is more to PostgreSQL administration than...
If you already know relational databases well and just want an introduction to PostgreSQL then this book is fine. If you are reading the Kindle version it has many links to more detailed or advanced information in blogs, articles, and the PostgreSQL documentation.
As the title suggests this book was instrumental in getting my PostgreSQL environment up and running.
The authorised South African distributor of this product is under no obligation to honour the manufacture's guarantees/warranties or to provide after-sales service.
Please note that this item is imported from the USA, and is designed to be used in the USA. In addition, if the unit is powered it will come with a US plug and an adapter/transformer may be required. Please click here for more information on power requirements, or check with us if you are unsure or need any assistance!
Please also note that certain items cannot be imported, these include Alcohol, Animals, Batteries, Flammable Materials, Currency, Food, Furs, Chemicals, Explosives, Medications, Plants, Seeds, Supplements, Pressurized Cans, Tactical Equipment, Vitamins, Weaponry and Weaponry Accessories. In these cases, the item and information is displayed for reference purposes only. If you are not sure if we are permitted to bring an item, please send us an e-mail with a link to the item to confirm.
Please also ensure that you are ordering the correct item for your particular application as returns to the USA are costly. Product reviews are also provided for most of our items, which can give you a good idea for possible things to look out for and the quality of the item. By clicking Add to Cart, you are confirming that the item is correct and you accept the conditions listed here.