PostgreSQL â " Up and Running

Obe, Regina O.,Hsu, Leo S.

ISBN 10: 1449373194 / ISBN 13: 9781449373191

Published by O'Reilly, 2014

About this Item

Most of our very good books have only minor imperfections such as shelf wear consistent with a new book that's sat on a bookshop shelf for a year or two. Occasionally we may miss other minor imperfections as we have to grade books at speed. Our books are dispatched from a Yorkshire former cotton mill. We list via barcode/ISBN so please note that the images are stock images and may not be the exact copy you receive, furthermore the details about edition and year might not be accurate as many publishers reuse the same ISBN for multiple editions and as we simply scan a barcode or enter an ISBN we do not check the validity of the edition data when listing. If you're looking for an exact edition please don't order (at least not without checking with us first, although we don't always have time to check). We aim to dispatch prompty, the service used will depend on order value and book size. We can ship to most countries, see our shipping policies. Payment is via Abe only.

Seller Inventory # mon0000118759

Bibliographic Details

• Title: PostgreSQL â " Up and Running
• Publisher: O'Reilly
• Publication Date: 2014
• Language: English
• ISBN 10: 1449373194
• ISBN 13: 9781449373191
• Binding: paperback
• Edition: 2nd Edition
• Condition: Very Good

About this title

Synopsis

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 use built-in replication filters to replicate data

About the Author

Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.