Thinking of migrating to Postgre SQL? This clear fast-paced introduction helps you understand & use this open source database system Not only will you learn about the enterprise class features in versions 95 to 10 you'll also discover that Postge SQL 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 & operator syntax introduced in version 96; XML constructs new in version 10; query parallelization features introduced in 96 & enhanced in 10; built-in logical replication introduced in Version 10e If you're a current Postgre SQL user you'll pick up gems you may have missed before Learn basic administration tasks such as role management database creation backup & restore Apply the psql comm&-line utility & the pg Admin graphical administration tool Explore Postgre SQL tables constraints & 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 & variegated data sources with foreign data wrappers Learn how to use built-in replication to replicate data