PostgreSQL: Up and Running

Thinking of migrating to PostgreSQL? This concise introduction helps you understand and use this open source database system. Not only will you learn about the new enterprise class features in versions 16 to 18, but you'll also discover all that PostgreSQL has to offer-much more than a relational database system. As an open source product, it has hundreds of plug-ins, expanding the capability of PostgreSQL beyond all other database systems.With examples throughout, this book shows you how to perform tasks that are difficult or impossible in other databases. The revised fourth edition covers the latest features of Postgres, such as ISO-SQL constructs rarely found in other databases, foreign data wrapper (FDW) enhancements, JSON constructs, multirange data types, query parallelization, and replication.If you're an experienced PostgreSQL user, you'll pick up gems you may have missed before.Learn basic administration tasks such as role management, database creation, backup, and restoreUse psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functions and stored proceduresTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with foreign data wrappersLearn how to use built-in replication to replicate data