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.5 to 10, you’ll also discover that PostgeSQL is
more than a database system—it’s an impressive application
platform as well. 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 9.6; XML constructs new in
version 10; query parallelization features introduced in 9.6 and
enhanced in 10; built-in logical replication introduced in Version
10.e. 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 to replicate data
General
Imprint: |
O'Reilly Media
|
Country of origin: |
United States |
Release date: |
October 2017 |
Authors: |
Regina Obe
• Leo Hsu
|
Dimensions: |
231 x 180 x 17mm (L x W x T) |
Format: |
Paperback
|
Pages: |
250 |
Edition: |
3rd Revised edition |
ISBN-13: |
978-1-4919-6341-8 |
Categories: |
Books
|
LSN: |
1-4919-6341-7 |
Barcode: |
9781491963418 |
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!