PostgreSQL : Up & Running: A Practical Guide to the Advanced Open Source Data...

PostgreSQL : Up & Running: A Practical Guide to the Advanced Open Source Database, Paperback by Obe, Regina O.; Hsu, Leo S., ISBN 1491963417, ISBN-13 9781491963418, Brand New, Free shipping in the US<div><p>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 to 10, you&#8217;ll also discover that PostgeSQL is more than a database system&#8212;it&#8217;s an impressive application platform as well.</p><p>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 XML constructs new in version 10; query parallelization features introduced in and enhanced in 10; built-in logical replication introduced in Version you&#8217;re a current PostgreSQL user, you&#8217;ll pick up gems you may have missed basic administration tasks such as role management, database creation, backup, and restore</li><li>Apply the psql command-line utility and the pgAdmin graphical administration tool</li><li>Explore PostgreSQL tables, constraints, and indexes</li><li>Learn powerful SQL constructs not generally found in other databases</li><li>Use several different languages to write database functions</li><li>Tune your queries to run as fast as your hardware will allow</li><li>Query external and variegated data sources with foreign data wrappers</li><li>Learn how to use built-in replication to replicate data</li></ul></div>