The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

Authentication failures and related problems generally manifest themselves through error messages like the following:

This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know.

The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one described

NameCREATE SEQUENCE -- define a new sequence generator Synopsis

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the

The examples in the previous section illustrated full text matching using simple constant strings. This section shows how to search table data, optionally using indexes.

Table 9-30 shows the available functions for date/time value processing, with details appearing in the following subsections. Table 9-29 illustrates the behaviors of the basic

Because roles can own database objects and can hold privileges to access other objects, dropping a role is often not just a matter of a quick