Refurbished favorites for less
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Leo Hsu
Follow
Regina Obe
Follow
Something went wrong. Please try your request again later.

PostgreSQL: Up and Running 1st Edition

by Regina (Author), Leonard Shihlien Hsu (Author)

If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.

With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases. 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 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 replicate data, using built-in replication features
Read more
Previous slide of product details
  1. ISBN-10
    1449326331
  2. ISBN-13
    978-1449326333
  3. Edition
    1st
  4. Publisher
    O'Reilly Media
  5. Publication date
    July 21, 2012
  6. Language
    English
  7. Dimensions
    7 x 0.36 x 9.19 inches
  8. Print length
    168 pages
Next slide of product details

From the brand

Previous page

  2. Sharing the knowledge of experts

    O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.

    Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.

  3. Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures
    Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Build...
    Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Proba...
    Learning Web Design: A Beginner's Guide to HTML, CSS, JavaScript, and Web Images

    Your partner in learning

    Visit the Store

  4. Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniqu...
    Hands-On Large Language Models: Language Understanding and Generation
    Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable ...
    AI Engineering: Building Applications with Foundation Models

    Bestsellers

    Visit the Store

  5. Fundamentals of Software Architecture: An Engineering Approach
    Platform Engineering: A Guide for Technical, Product, and People Leaders
    Facilitating Software Architecture: Empowering Teams to Make Architectural Decisions
    Building Green Software: A Sustainable Approach to Software Development and Operations

    Software Development

    Visit the Store

  6. Fluent Python: Clear, Concise, and Effective Programming
    JavaScript: The Definitive Guide: Master the World's Most-Used Programming Language
    Learning Java: An Introduction to Real-World Programming with Java
    Programming Rust: Fast, Safe Systems Development

    Programming Languages

    Visit the Store

  7. Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniqu...
    Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
    Hands-On Generative AI with Transformers and Diffusion Models
    Prompt Engineering for LLMs: The Art and Science of Building Large Language Model–Based Applications

    AI / Machine Learning

    Visit the Store

  8. Learning Data Science: Data Wrangling, Exploration, Visualization, and Modeling with Python
    Data Science from Scratch: First Principles with Python
    Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Proba...
    Data Science: The Hard Parts: Techniques for Excelling at Data Science

    Data Science

    Visit the Store

  9. Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
    Database Internals: A Deep Dive into How Distributed Data Systems Work
    Fundamentals of Data Engineering: Plan and Build Robust Data Systems
    Learning Data Science: Data Wrangling, Exploration, Visualization, and Modeling with Python

    Data, Databases and more

    Visit the Store

  10. Building Microservices: Designing Fine-Grained Systems
    System Design on AWS: Building and Scaling Enterprise Solutions
    Cloud Native Infrastructure with Azure: Building and Managing Cloud Native Applications
    Hacking Kubernetes: Threat-Driven Analysis and Defense

    Cloud Services

    Visit the Store

  11. The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
    The Art of Leadership: Small Things, Done Well
    Laws of UX: Using Psychology to Design Better Products & Services
    Product Leadership: How Top Product Managers Launch Awesome Products and Build Successful Teams

    Business

    Visit the Store

  12. Financial Data Engineering: Design and Build Data-Driven Financial Products
    Deep Learning for Finance: Creating Machine & Deep Learning Models for Trading in Python
    Reinforcement Learning for Finance: A Python-Based Introduction
    Artificial Intelligence in Finance: A Python-Based Guide

    Finance

    Visit the Store

  13. Mastering Blockchain: Unlocking the Power of Cryptocurrencies, Smart Contracts, and Decentralized...
    Blockchain Tethered AI: Trackable, Traceable Artificial Intelligence and Machine Learning
    Programming Bitcoin: Learn How to Program Bitcoin from Scratch
    Mastering the Lightning Network: A Second Layer Blockchain Protocol for Instant Bitcoin Payments

    Blockchain / Cryptocurrency

    Visit the Store

  14. Security as Code: DevSecOps Patterns with AWS
    Inside Cyber Warfare: Mapping the Cyber Underworld
    Security Chaos Engineering: Sustaining Resilience in Software and Systems
    Container Security: Fundamental Technology Concepts that Protect Containerized Applications

    Security

    Visit the Store

  15. Arduino Cookbook: Recipes to Begin, Expand, and Enhance Your Projects
    SQL Cookbook: Query Solutions and Techniques for All SQL Users
    AWS Cookbook: Recipes for Success on AWS
    Web Accessibility Cookbook: Creating Inclusive Experiences

    Cookbooks

    Visit the Store

  16. Head First Java: A Brain-Friendly Guide
    Head First Software Architecture: A Learner's Guide to Architectural Thinking
    Head First Python: A Learner's Guide to the Fundamentals of Python Programming, A Brain-Friendly ...
    Head First Design Patterns: Building Extensible and Maintainable Object-Oriented Software 2nd Edi...

    Head First series

    Visit the Store

  17. 97 Things Every Engineering Manager Should Know: Collective Wisdom from the Experts
    97 Things Every Information Security Professional Should Know: Collective Wisdom from the Experts
    97 Things Every UX Practitioner Should Know: Collective Wisdom from the Experts
    97 Things Every Data Engineer Should Know: Collective Wisdom from the Experts

    97 Things series

    Visit the Store

  18. Running Lean: Iterate from Plan A to a Plan That Works
    Lean Analytics: Use Data to Build a Better Startup Faster
    Lean UX: Designing Great Products with Agile Teams
    Lean AI: How Innovative Startups Use Artificial Intelligence to Grow

    Lean series

    Visit the Store

Next page

Editorial Reviews

Book Description

A Practical Guide to the Advanced Open Source Database

From the Back Cover

  • 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 replicate data, using built-in replication features

Product details

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Leo Hsu

    Leo Hsu

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
  2. Regina Obe

    Regina Obe

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
Next page

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Shop the Store on Amazon ›
    Greenlight Your Tech Career: Beginner’s Guide to Self-Taught Programming After the AI Revolution and Getting Hired Fast Without a Degree Through Real-World Coding Experience
    Greenlight Your Tech Career: Beginner’s Guide to Self-Taught Programming After the AI Revolution and Getting Hired Fast Without a Degree Through Real-World Coding Experience
    4.54.5 out of 5 stars205
    $19.99
  2. Shop the Store on Amazon ›
    Chasing Clouds: A Sky-High Adventure
    Chasing Clouds: A Sky-High Adventure
    5.05.0 out of 5 stars16
    $12.00
Next page

Customer reviews

3.6 out of 5 stars
38 global ratings

Top reviews from the United States

  • JimF
    5.0 out of 5 stars Great book
    Reviewed in the United States on April 12, 2014
    Format: PaperbackVerified Purchase
    This book targets people with a good understanding of database technology. It doesn't spend time on explaining the basics, just summarizes the PostgreSQL technology and provide more than a few good references to the source documentation.
    One person found this helpful
    Helpful
     Report
  • Ed Behn
    4.0 out of 5 stars Good but by no means complete
    Reviewed in the United States on September 17, 2015
    Format: PaperbackVerified Purchase
    This is a good light-weight intro to PostgreSQL. If you don't know where to start, this is a good place. It should be noted that PostgreSQL's official documentation is excellent and the first chapter is a step-by-step setup. The biggest shortcoming of this book it the fact that it inexplicably lacks an index.
    One person found this helpful
    Helpful
     Report
  • Kyle Bishop
    2.0 out of 5 stars Not Enough Where It Counts
    Reviewed in the United States on August 7, 2013
    Format: PaperbackVerified Purchase
    I'm a big fan of O'Reilly books in general and have come to expect a high level of quality from them. In light of their good record with me, this book was an extreme disappointment. I understood when I got this book that it was meant to be the quicker guide to learning and administrating PostgreSQL and had expected that it would at least be able to act as a good reference book. I came into the book knowing MySQL and was generally okay with SQL and how relational databases work.

    However, this book took the what you must know before hand to an extreme level and doesn't even act as a very good reference. First, you must know ANSI SQL in and out before using this book. The book fails to teach the nuances of PostgreSQL because it can always fall back on "well, you should know ANSI SQL before reading this book and PostgreSQL is completely ANSI SQL compliant, therefore we don't need to explain this." It will often throw code at you without much prose.

    Its larger failing is the failure to act as a good reference. Almost every paragraph of the book is cut short with "well, you can read the PostgreSQL manual here" followed by a url to the relevant manual page. It's not a reference or an explanation in itself, but rather a reference of where to go to find what you really want. Instead of buying this book for either learning or reference, you would be better off taking your $18 and just getting a nice printed copy of the PostgreSQL manual, since all this book does effectively is point you to it.
    5 people found this helpful
    Helpful
     Report
  • AK
    3.0 out of 5 stars Three Stars
    Reviewed in the United States on January 16, 2015
    Format: PaperbackVerified Purchase
    Covers some stuff. I had expected a little more on writing PSQL functions.
    Helpful
     Report
  • G. van Staden
    5.0 out of 5 stars Short Friendly Introduction to PosgreSQL
    Reviewed in the United States on August 13, 2012
    PostgreSQL is something I always wondered about having seen its use in Google Earth Enterprise and a few other products. This book helps those with some experience in databases understand this interesting application platform. The run-of-the mill relational database features (datatypes, database objects and such) are covered briefly but the focus of the book is on what makes PostgreSQL unique. Good points of consideration concerning the applicability of PostgreSQL are provided making this a good book for professionals thinking about using PostgreSQL in their projects.

    The book does a good job of distilling the vast on-line content surrounding PostgreSQL and explains the tools surrounding it a bit better than the documentation provided for them (in particular pgAdmin). Installation, configuration, security, database object management, functions (in SQL and Python) as well as performance tuning are covered. Don't expect elaborate coverage of the topics. I enjoyed this conciseness but there were times I had to used the provided references (links) to on-line material to get a better understanding.

    Any reader must be aware that the book focuses on PostgreSQL 9.1. It does mention where there are differences with older versions but you might be left wanting if you are stuck with an older version.

    It's short and powerful introduction to PostgreSQL's core features and approach. Many useful links to PostgreSQL resources are included. This book was enjoyable to read and perfect for getting me up-to-speed with PostgreSQL.
    10 people found this helpful
    Helpful
     Report
  • Michael Kress
    4.0 out of 5 stars Four Stars
    Reviewed in the United States on December 30, 2014
    Format: PaperbackVerified Purchase
    Fine.
    Helpful
     Report
  • Ian Gow
    5.0 out of 5 stars Up and running plus
    Reviewed in the United States on June 10, 2013
    Format: Paperback
    I think the title is accurate; the book helps users get "up and running" with PostgreSQL. I think that getting "up and running" with PostgreSQL is difficult relative to systems like SQLite or MySQL for users like myself who aren't running websites, but like the structure and power of SQL for maintaining data (research-related data in my case). Once one gets over that hurdle (I end up compiling from source), PostgreSQL is well worth the initial investment.

    The authors went a little further and introduced other features of PostgreSQL, including window functions and procedural languages. I see some value in covering these topics to people new to PostgreSQL, as they help encourage people to make the leap. I can see value in future editions pushing the latter aspect of the book further (perhaps in a separate book), but for now the authors did an admirable job in the limited space of the book.
    3 people found this helpful
    Helpful
     Report
  • Theodore D. Sternberg
    2.0 out of 5 stars Misleading title, misleading reviews
    Reviewed in the United States on April 22, 2013
    Format: PaperbackVerified Purchase
    This is not an introduction to PostgreSQL. It's certainly not a "tutorial", as another reviewer claims. A better title would be "PostgreSQL Tips and Tricks". This book won't make much sense until you've already familiarized yourself with PostgreSQL's online documentation. As for how useful those tips and tricks are, I can't say. I came to this book with a solid academic understanding of databases (at the level of Ullman's Principles of Database & Knowledge-Base Systems, Vol. 1: Classical Database Systems) and some light experience with Oracle and PostgreSQL itself. With that as my background, this book didn't offer me much. However, I do intend to learn a lot about PostgreSQL (at this, point, I guess, from its own online documentation), at which point I will return to this book and have more to say. But for now, my warning stands: if you're looking for an introduction or a tutorial, look somewhere else.

    As a secondary point, the English in this book is bad enough to be annoying. O'Reilly should be concerned enough about its reputation to hire an editor who understands noun-verb agreement (e.g. "the dog bites the man", not 'the dog bite the man").
    36 people found this helpful
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • Guillaume Lelarge
    5.0 out of 5 stars Un bon livre de débutant sur PostgreSQL
    Reviewed in France on August 31, 2012
    Verified Purchase
    Simple et facile à lire, il permet de bien commencer avec PostgreSQL. Ce n'est clairement pas un livre pour expert mais il ravira tous les débutants qui veulent utiliser un vrai moteur de bases de données.
    Report
  • Jay Godse
    5.0 out of 5 stars Useful
    Reviewed in Canada on November 7, 2013
    Format: PaperbackVerified Purchase
    This is a useful goto guide for everything PostgreSQL. It shows you how to do most useful functions. Definitely going to be on my tool belt with my next PostgreSQL project.
    Report
  • Egbert König
    5.0 out of 5 stars Sehr hilfreich
    Reviewed in Germany on February 5, 2013
    Verified Purchase
    Dieses Buch ist ein typisches O'Reilly Buch, genau richtig geschrieben. Der Text ist kurz und prägnant, die Anleitungen im Buch haben mir sehr weitergeholfen.
    Report
  • Paras Divaker
    5.0 out of 5 stars Good and clear explanation
    Reviewed in India on January 21, 2018
    Verified Purchase
    Good and clear explanation on important topics. Overall a good book for those who want to learn rapidly growing PostgreSQL database.
    Report
  • richardtoohey
    5.0 out of 5 stars Exactly what it says on the cover
    Reviewed in the United Kingdom on September 30, 2012
    Format: PaperbackVerified Purchase
    I'm a MySQL user wondering about other open source options (and wondering where Oracle is going to take MySQL) and this book was a good introduction to modern PostgreSQL and what's good/different about it.

    I already have some PostgreSQL books but they are for older versions - I wanted a good introduction including some of the 9.x features, and this book didn't disappoint.

    It is a short text - but it is about "Up and Running" - and that's exactly what you get. It's good for giving you ideas (and links to where you can find out more) - so it touches on lots of things and if you are interested, you'll know where to go to find out more.

    There's no padding to boost up the page count.

    If you are looking for an in-depth tome on every feature - this won't be the book for you. If you want an introduction to SQL, it's not here. BUT if you want something easy-to-read that gives you a good overall feel for PostgreSQL and what it is capable of - buy it!
    Report