PostgreSQL enforces SQL uniqueness constraints using unique indexes, which are indexes that disallow multiple entries

PostgreSQL allows functions that have named parameters to be called using either positional or named

Inheritance is a concept from object-oriented databases. It opens up interesting new possibilities of database design. Let's create two tables:

So far we have explained how to add data to tables and how to change data. What remains is to discuss how to remove data that is no longer needed. Just as adding data is only

The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the

It is possible to use SSH to encrypt the network connection between clients and a PostgreSQL server. Done

Asynchronous commit is an option that allows transactions to complete more quickly, at the cost that the most recent transactions may be lost if the

This chapter provides an overview of how to use SQL to perform simple operations. This tutorial is only intended to give you an introduction

The pg_freespacemap module provides a means for examining the free space map (FSM). It provides a function called pg_freespace

The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently