The functions described in this section are used to control and monitor a PostgreSQL installation.

Table 9-42 shows the operators that are available for use with the two JSON data types (see Section 8.14)

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

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

The examples shown below use tables in the PostgreSQL regression test database. The outputs shown are taken from version 8.3. The behavior

The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that