Learn PostgreSQL : use, manage, and build secure and scalable databases with PostgreSQL 16

Learn PostgreSQL use, manage, and build secure and scalable databases with PostgreSQL 16

The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to...

Descripción completa

Detalles Bibliográficos
Otros Autores: Ferrari, Luca (Computer scientist), author (author), Pirozzi, Enrico, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing Ltd 2023.
Edición:Second edition
Materias:
PostgreSQL.
Database management.
SQL (Computer program language)
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009781231506719
Tabla de Contenidos:
  • Cover
  • Copyright
  • Contributors
  • Table of Contents
  • Preface
  • Chapter 1: Introduction to PostgreSQL
  • Technical requirements
  • PostgreSQL at a glance
  • A brief history of PostgreSQL
  • What's new in PostgreSQL 16?
  • PostgreSQL release policy, version numbers, and life cycle
  • Exploring PostgreSQL terminology
  • Installing PostgreSQL
  • What to install
  • Installing PostgreSQL from binary packages
  • Using the book's Docker images
  • Installing PostgreSQL on GNU/Linux Debian, Ubuntu, and derivatives
  • Installing PostgreSQL on Fedora Linux
  • Installing PostgreSQL on FreeBSD
  • Installing PostgreSQL from sources
  • Installing PostgreSQL via pgenv
  • Summary
  • References
  • Chapter 2: Getting to Know Your Cluster
  • Technical requirements
  • Managing your cluster
  • pg_ctl
  • PostgreSQL processes
  • Connecting to the cluster
  • The template databases
  • The psql command-line client
  • Entering SQL statements via psql
  • A glance at the psql commands
  • Introducing the connection string
  • Solving common connection problems
  • Database "foo" does not exist
  • Connection refused
  • No pg_hba.conf entry
  • Exploring the disk layout of PGDATA
  • Objects in the PGDATA directory
  • Tablespaces
  • Exploring configuration files and parameters
  • Summary
  • Verify your knowledge
  • References
  • Chapter 3: Managing Users and Connections
  • Technical requirements
  • Introduction to users and groups
  • Managing roles
  • Creating new roles
  • Role passwords, connections, and availability
  • Using a role as a group
  • Removing an existing role
  • Inspecting existing roles
  • Managing incoming connections at the role level
  • The syntax of pg_hba.conf
  • Order of rules in pg_hba.conf
  • Merging multiple rules into a single one
  • Using groups instead of single roles
  • Using files instead of single roles
  • Inspecting pg_hba.conf rules
  • Including other files in pg_hba.conf
  • Summary
  • Verify your knowledge
  • References
  • Chapter 4: Basic Statements
  • Technical requirements
  • Using the Docker image
  • Connecting the database
  • Creating and managing databases
  • Creating a database
  • Managing databases
  • Introducing schemas
  • PostgreSQL and the public schema
  • The search_path variable
  • The correct way to start working
  • Listing all tables
  • Making a new database from a modified template
  • Dropping tables and databases
  • Dropping tables
  • Dropping databases
  • Making a database copy
  • Confirming the database size
  • The psql method
  • The SQL method
  • Behind the scenes of database creation
  • Managing tables
  • The EXISTS option
  • Managing temporary tables
  • Managing unlogged tables
  • Creating a table
  • Understanding basic table manipulation statements
  • Inserting and selecting data
  • NULL values
  • Sorting with NULL values
  • Creating a table starting from another table
  • Updating data
  • Deleting data
  • Summary
  • Verify your knowledge
  • References

Ejemplares similares