Author Description

Annotation If youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9.2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform. With numerous examples throughout this book, youll learn how to achieve tasks that are difficult or impossible in other databases. If youre an existing PostgreSQL user, youll pick up gems you may have missed along the way. Learn basic administration tasks, such as role management, database creation, backup, and restoreApply the 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 functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with Foreign Data WrappersLearn how to replicate data, using built-in replication features.