Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Learning PostgreSQL 10

You're reading from Learning PostgreSQL 10 A beginner's guide to building high-performance PostgreSQL database solutions

Product type Paperback

Published in Dec 2017

Publisher

ISBN-13 9781788392013

Length 488 pages

Edition 2nd Edition

Languages

C

Tools

PostgreSQL

Concepts

Database Programming

Authors (2):

Juba

Volkov

View More author details

Table of Contents (23) Chapters

Title Page

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Customer Feedback

Preface

1. Relational Databases

2. PostgreSQL in Action FREE CHAPTER

3. PostgreSQL Basic Building Blocks

4. PostgreSQL Advanced Building Blocks

5. SQL Language

6. Advanced Query Writing

7. Server-Side Programming with PL/pgSQL

8. OLAP and Data Warehousing

9. Beyond Conventional Data Types

10. Transactions and Concurrency Control

11. PostgreSQL Security

12. The PostgreSQL Catalog

13. Optimizing Database Performance

14. Testing

15. Using PostgreSQL in Python Applications

16. Scalability

Summary

PostgreSQL provides a complete programming language called PL/pgSQL, which is integrated with the PostgreSQL trigger system. The PL/pgSQL and SQL languages can be used to code very complex logic. One should use the SQL functions when possible. With the introduction of advanced query writing techniques such as window functions and lateral Join in PostgreSQL, one can write very complex logic using only the standard SQL language.

There are several parameters in PostgreSQL for controlling function behavior; these parameters are applicable to the PL/pgSQL and SQL functions as well. For example, SECURITY DEFINER and SECURITY INVOKER define the execution security context and privileges. Function's planner parameters help the planner to generate execution plans. These parameters are COST, LEAKPROOF, and ROWS. Configuration related parameters can also be applied to functions.

PL/pgSQL is a fully fledged language, there are statements for assignment, conditionals, iterations, and for exception...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at £13.99/month. Cancel anytime

Authors (2)

Juba

Juba

Salahaldin Juba has over than a decade of experience in the industry and academia, with a focus on database development for large-scale and enterprise applications. He holds a master's degree of science in environmental management with a distinction, and a bachelor's degree of engineering in computer systems. He is also a Microsoft Certified Solution Developer (MCSD). He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.

See other products by Juba

Volkov

Volkov

Andrey Volkov studied information systems in banking, and started his career as a financial analyst at a commercial bank. He joined a data warehouse team, and after some time, he lead the team by taking the position of the data warehouse architect. There he worked mainly with Oracle database stack and used it to develop logical and physical models of financial and accounting data, implement them in the database, develop ETL processes, and perform analytical tasks. Now Andrey works as a senior database developer at a telecommunication provider. There, he works mainly with PostgreSQL databases, being responsible for data modeling, developing a data warehouse, reporting, and billing systems.

See other products by Volkov

Other recommended products

Related to this chapter

Learning PostgreSQL 11

Learning PostgreSQL 11

This book will get you up and running with building efficient relational database solutions right from scratch with the newest features of PostgreSQL 11. You will learn the end-to-end working of relational databases and how to work with database structures. You will also be able to write essential SQL statements, perform data manipulation and do more, with the help of this book.

Jan 2019 18h 32m

PostgreSQL High Performance Cookbook

PostgreSQL High Performance Cookbook

This book will guide you to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. You will be a able to perform various essential database tasks such as bench marking the database and optimizing the server's memory usage. This book will also help you to explore various memory optimization techniques offered by PostgreSQL.

Mar 2017 12h 0m

Learn PostgreSQL

Learn PostgreSQL

This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You'll also be able to identify bottlenecks to enhance the performance of database applications.

Oct 2020 21h 40m

PostgreSQL 13 Cookbook

PostgreSQL 13 Cookbook

PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also discover how to administer and secure the database.

Feb 2021 11h 28m

PostgreSQL 11 Server Side Programming Quick Start Guide

PostgreSQL 11 Server Side Programming Quick Start Guide

PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables strong data encapsulation and coherence.

Nov 2018 8h 40m

Mastering PostgreSQL 12

Mastering PostgreSQL 12

This book includes the newly introduced features in PostgreSQL 12, and shows you how to build better PostgreSQL applications, and administer your database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build secured and fault-tolerant database solutions.

Nov 2019 15h 40m

Mastering PostgreSQL 10

Mastering PostgreSQL 10

PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently.

Jan 2018 14h 16m

Mastering PostgreSQL 11

Mastering PostgreSQL 11

This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solutions.

Oct 2018 14h 52m

Mastering PostgreSQL 13

Mastering PostgreSQL 13

Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You'll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly available database solutions.

Nov 2020 15h 52m

Mastering PostgreSQL 9.6

Mastering PostgreSQL 9.6

PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.

May 2017 13h 52m

PostgreSQL 11 Administration Cookbook

PostgreSQL 11 Administration Cookbook

PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL 11 solution.

May 2019 20h 0m

PostgreSQL 10 Administration Cookbook

PostgreSQL 10 Administration Cookbook

PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution.

May 2018 19h 12m

Personalised recommendations for you

Based on your interests and search pattern

Mathematics of Machine Learning

Mathematics of Machine Learning

Deepen your theoretical knowledge and enhance your ability to solve complex machine learning problems with structured guidance. Gain the confidence to engage with advanced ML literature and tailor algorithms to meet your project requirements.

May 2025 24h 20m

Generative AI with Python and PyTorch

Generative AI with Python and PyTorch

Learn how to create images and text using VAEs, GANs, LSTMs, and transformers. Implement applications in natural language processing and computer vision through practical tutorials.

Mar 2025 15h 0m

Practical Generative AI with ChatGPT

Practical Generative AI with ChatGPT

This book helps you unlock ChatGPT's potential to make your working life better. From prompt engineering to creating custom GPTs, you'll enhance your productivity, creativity, and efficiency with practical insights and advanced techniques.

Apr 2025 12h 52m

Generative AI with LangChain

Generative AI with LangChain

Gain a solid foundation in LangChain, agentic AI, and LangGraph, and learn to build production-ready systems with multi-agent architectures, advanced RAG pipelines, Tree of Thought reasoning, agent handoffs, and fine-grained error handling.

May 2025 15h 52m

Architecting Power BI Solutions in Microsoft Fabric

Architecting Power BI Solutions in Microsoft Fabric

Power BI provides several options to solve common data problems, and designing the correct solution for each scenario can be a daunting task. This book makes it easier by guiding you through designing optimal solutions using Power BI.

Apr 2025 14h 16m

Microsoft Identity and Access Administrator SC-300 Exam Guide

Microsoft Identity and Access Administrator SC-300 Exam Guide

This comprehensive guide covers key topics such as Microsoft Entra ID implementation, authentication and access management, external user management, and hybrid identity solutions, providing practical insights and techniques for SC-300 exam success.

Mar 2025 19h 48m

LLM Design Patterns

LLM Design Patterns

This book helps you gain practical skills to develop and deploy LLMs. You'll learn data prep, training, pruning, quantization, and evaluation, as well as explore RAG, advanced prompting, and optimization to build robust, scalable language models.

May 2025 17h 48m

Tableau Cookbook for Experienced Professionals

Tableau Cookbook for Experienced Professionals

Advance your Tableau knowledge beyond the basics, streamline dashboard performance, tackle advanced geospatial challenges, and unlock API potential while fortifying your corporate data infrastructure with proven best practices.

Apr 2025 12h 24m

Time Series Analysis with Spark

Time Series Analysis with Spark

This book offers a complete guide to time series analysis with Apache Spark and Databricks, covering essential concepts and advanced techniques including Generative AI to equip readers with skills for real-world challenges across industries.

Mar 2025 9h 56m

Hands-On Artificial Intelligence for IoT

Hands-On Artificial Intelligence for IoT

Transform IoT systems with the power of artificial intelligence using this hands-on guide. Dive into practical techniques and expert insights to innovate and optimize your IoT devices, making them smarter and more efficient.

May 2025 15h 44m