PostgreSQL Developer's Guide (Repost)

Design, develop, and implement streamlined databases with PostgreSQL About This Book Design efficient, real-world database solutions and extend your knowledge of database concepts Learn how to program using native PostgreSQL procedural languages to write custom functions Explore database partitioning and learn about query optimization techniques Who This Book Is For If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required What You Will Learn Refresh your knowledge of SQL with PostgreSQL-supported DDL and DML Explore native PostgreSQL procedural languages and learn how to write custom functions Leverage the power of indexes for optimal database efficiency Unfold tricky trigger concepts and implement them in native procedural languages Discover how to implement views, partitioned tables, and window functions in PostgreSQL Design efficient queries with query optimization and query analysis Communicate with PostgreSQL servers using foreign data wrappers such as LibPQ and ECPG Extend database powers using foreign data wrappers and achieve maintainability via PostgreSQL extensions